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

1. Provide a descriptive name for your data source

2. Optionally create and share a collection