Connecting to PostgreSQL
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
Connect Publisher to PostgreSQL databases to access and share your data. This connection requires your PostgreSQL database credentials and connection details.
Prerequisites
Before beginning, gather these database details:
Username
Password
Host name
Port number
Database name
Configuration Process
Initial Setup
From the Publisher interface, select "Data Sources" in the navigation bar and click "Connect Data Source". Choose "PostgreSQL Database" from the available connectors.
Database Configuration
Enter your PostgreSQL connection details:
Database username and password
Host name
Port number (default is typically 5432)
Database name
Enable TLS if required for your connection
Ensure your database user has appropriate permissions for the data you wish to access and that your network security settings allow the connection.
Finalizing Setup
Provide a descriptive name for your data source
Optionally create and share a collection
Last updated