Basedash

How to find get your Postgres connection URI when using Basedash

Step 1: Find your database

Navigate to the Basedash Connections page. In the left panel, scroll down to the bottom to see your databases. Click on the gear icon of the database you want to connect:

Connection settings for a database

Click "Manage credentials":

Manage credentials for a database

Step 2: Construct the connection URI

On the "Manage credentials" page, you should see a "SQL connection overview" section:

SQL connection overview

Construct the connection URI with the above fields and replace YOUR_PASSWORD with the correct password. Using the example values above, the connection URI would look like this:

postgresql://postgres:YOUR_PASSWORD@18.18.98.1:5432/postgres

This is the string you will paste into the Whalesync Postgres connection dialog:

Enter your Postgres connection URI into Whalesync

Caveats

Note that Whalesync does not yet support:

• Whitelisted IP addresses

• Custom SSL/TLS certificates

If you need these to connect to your instance, please reach out and let us know.