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 `__. .. 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 `__ 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.