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:

Screenshot of the settings icon for a database connection in Basedash
Connection settings for a database

Click "Manage credentials":

Screenshot of the manage credentials button in Basedash
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 page in Basedash
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:

Screenshot of 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.

Last updated

Was this helpful?