Amazon RDS

This page contains additional instructions that are relevant to databases hosted on Amazon Web Services (AWS RDS).

Permitting Inbound Connections

If you have a database such as PostgreSQL or MySQL hosted on AWS, the following steps will permit connections to it from your local computer:

  1. On the AWS admin site, go to the RDS Console.
  2. In the sidebar to the left, click Databases.
  3. Click the database you would like to connect to.
  4. Under VPC security groups (third column in the Connectivity & security tab), click the security group.
  5. Click the Inbound rules tab in the lower half of the screen, and then Edit inbound rules.
  6. Click Add rule. Under Type, select the database type (e.g. PostgreSQL or MySQL/Aurora). Under Source, select My IP.
  7. Click Save rules. Wait 10 seconds.
  8. You should be able to connect to your database from tools running locally on your computer, such as Ultorg. If your computer's IP address later changes, you may need to update the inbound rule again on AWS.

More complex AWS configurations may require a different way to connect to the database, such as SSH tunneling.

SSL Configuration

To configure SSL, see the specific instructions for your database (PostgreSQL, MySQL, Microsoft SQL Server). Root certificates for AWS, which are used by the client to verify the server's identity, can be found here.