How do I connect to the RDS instance?

Setup and SSH tunneling to the Moped RDS instance

Moped runs on a PostgreSQL database in AWS, but it is not publicly accessible. It currently lives in a closed (private) network, where only one server has access to it. This server is a virtual machine (EC2 instance) on AWS, and it is carefully placed in the same network and VPC as the database, and it acts as a proxy.

In short, to connect to the PostgreSQL database, you will need two sets of credentials:

  1. An SSH Key. The ssh key needs to be generated by you in your computer, and an admin needs to set up that key in the bastion host for you to have access. The SSH tunnel will be taken care of by your PostgreSQL client. You can learn more about this here.

  2. The PostgreSQL username/password. Once your machine is connected to the bastion host, you will be able to directly connect against the PostgreSQL client. You can learn more about this here.

PreviousHow do I connect a database with Postgres GUIs?NextHow to load production data into a local instance

Last updated

Was this helpful?