PostgreSQL

Prerequisites

• Data source allows access to LogicLoop if necessary

• Deployment works for organization and data source

• LogicLoop user account is an admin to be able to create a data source

Setup

Connecting your Postgres database to LogicLoop is easy. If you're an admin user, you will be able to go to the Settings panel and add a new data source of type Postgres.

Next, enter your Postgres database credentials. You can hit the 'Test Connection' button to see if it worked.

Getting credentials from Heroku

If you use Heroku, you can find your database credentials by going to your app and clicking on your database Postgres add on.

Under that database's settings, click on View Credentials.

Copy and paste the credentials to the corresponding LogicLoop fields.

If your Postgres is hosted by a private space like Heroku Enterprise and requires mTLS for connection, we support that by allowing you to upload your SSL certs and keys under Additional Settings. The key provided must be in either the PKCS-12 or PKCS-8 DER format.