PostgreSQL

Setting up PostgreSQL

Select PostgreSQL from the integrations page.

Fill out the form with the following settings:

Setting	Required	Description
Name	✓	Name that will be displayed to users when selecting this integration in Superblocks
Host	✓	Hostname or IP address to connect to
Port	✓	Port to use when connecting to PostgreSQL
Database Name	✓	Name of database to connect to
Database Username	✓	Username to use to connect
Database Password	✓	Password for database username
Enable SSL	✗	Connect using SSL
Use a self-signed SSL certificate	✗	Provide Server CA, Client Key, and Client Cert
Use SSH Tunnel	✗	Connect via an SSH tunnel. See configuration details here.

Click Test Connection to check that Superblocks can connect to the data source.

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).

After connecting successfully, click Create to save the integration.

Optionally, configure different profiles for separate development environments.

PostgreSQL connected!
Now you can use PostgreSQL in any Application, Workflow, or Scheduled Job.

Check out our guide on common errors across database integrations, in addition to common Postgres connection issues. If you are encountering an error that you don’t see in the guide, or the provided steps are insufficient to resolve the error, please contact us at [email protected].