AWS (RDS)

How to find get your Postgres connection URI when using Amazon Web Services RDS

Step 1: Find your database

Navigate to the AWS RDS dashboard. In the left panel you should see "Databases":

Screenshot of the AWS RDS side panel
Databases page

In this list, select your database:

Screenshot of the AWS RDS database list
Database list in RDS

Step 2: Construct the connection URI

On the main database page, you should have the "Connectivity & security" tab selected. Note the endpoint and port number:

Screenshot of the AWS RDS endpoint and port information
RDS endpoint and port number

Next under the "Configuration" tab, look up the username. You can also create a different user for Whalesync to connect, but for simplicity we'll use the master username:

Screenshot of AWS RDS database configuration
RDS configuration with the username

The password was set when the database was originally created. Please ask whoever set up the database for the connection password.

Finally, construct the connection URI like this and replace YOUR_PASSWORD with the password:

postgresql://postgres:YOUR_PASSWORD@postgres-connector-test.000000000000.us-east-1.rds.amazonaws.com: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?