AWS (RDS)

Find your Amazon RDS endpoint, port, and username, build the Postgres connection URI for Whalesync, and allowlist Whalesync's IP in your security group.

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

If your database only accepts connections from known IP addresses, allowlist Whalesync's static IP. See Allowlisting Whalesync IP addresses.

Note that Whalesync does not yet support custom SSL/TLS certificates. If you need them to connect to your instance, please reach out and let us know.