mirror of
https://github.com/Unstructured-IO/unstructured.git
synced 2025-07-08 01:22:43 +00:00
2afd347e6b
To test: > cd docs && make html Structures: * Getting Started with Platform (User Account Management) * Set Up workflow automation * Job Scheduling * Platform Source Connectors: * Azure Blob Storage, * Amazon S3 * Salesforce * Sharepoint * Google Cloud Storage * Google Drive * One Drive * Elasticsearch * SFTP Storage * Platform Destination Connectors: (i) * Amazon S3 * Azure Cognitive Search * Google Cloud Storage * Pinecone * Elasticsearch * Weaviate * MongoDB * AWS OpenSearch * Databricks --------- Co-authored-by: Matt Robinson <mrobinson@unstructured.io> Co-authored-by: Matt Robinson <mrobinson@unstructuredai.io>
40 lines
1.8 KiB
ReStructuredText
40 lines
1.8 KiB
ReStructuredText
PostgreSQL
|
|
==========
|
|
|
|
This page contains the information to store processed data to a PostgreSQL database.
|
|
|
|
Prerequisites
|
|
--------------
|
|
|
|
- PostgreSQL Server Hostname
|
|
- Database Name and Port Number
|
|
- Username and Password for Database Access
|
|
|
|
For more information, please refer to `PostgreSQL documentation <https://www.postgresql.org/docs/>`__.
|
|
|
|
.. warning::
|
|
Ensure that the index schema is compatible with the data you intend to write.
|
|
If you need guidance on structuring your schema, consult the `Sample Index Schema <https://unstructured-io.github.io/unstructured/ingest/destination_connectors/sql.html#sample-index-schema>`__ for reference.
|
|
|
|
|
|
Step-by-Step Guide
|
|
-------------------
|
|
|
|
.. image:: imgs/Destination-PostgreSQL.png
|
|
:alt: Destination Connector PostgreSQL
|
|
|
|
1. **Access the Create Destination Page**. Navigate to the "Destinations" section within the platform's side navigation menu and click on "New Destination" to initiate the setup of a new destination for your processed data.
|
|
|
|
2. **Select Destination Type**. Select **PostgreSQL** destination connector from the ``Type`` dropdown menu.
|
|
|
|
3. **Configure Destination Details**
|
|
|
|
- ``Name`` (*required*): Assign a descriptive name to the new destination connector.
|
|
- ``Host`` (*required*): Enter the hostname or IP address of the PostgreSQL server.
|
|
- ``Database`` (*required*): Provide the name of the PostgreSQL database.
|
|
- ``Port``: Specify the port number for the PostgreSQL server (default is 5432).
|
|
- ``Username``: Input the username for the PostgreSQL database access.
|
|
- ``Password``: Enter the password associated with the username.
|
|
|
|
4. **Submit**. Review all the details entered to ensure accuracy. Click 'Submit' to finalize the creation of the Destination Connector. The newly completed PostgreSQL connector will be listed on the Destinations dashboard.
|