Connecting to PostgreSQL
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
Last updated
Was this helpful?
PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.
Last updated
Was this helpful?
Connect to databases to access and share your data. This connection requires your PostgreSQL database credentials and connection details.
Before beginning, gather these database details:
Username
Password
Host name
Port number
Database name
From the Publisher interface, select "Data Sources" in the navigation bar and click "Connect Data Source". Choose "PostgreSQL Database" from the available connectors.
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.
Provide a descriptive name for your data source
Optionally create and share a collection