Amazon RDS – PostgreSQL Connecting to DB

To connect to Amazon RDS PostgreSQL DB we need a client software. In this case we use pgAdmin.

After it is successfully installed we follow the steps below to connect it to the Amazon RDS.

Step-1

From the DB instance details get the end point.

pgadmin_db_details.JPG

Step-2

As it is a browser based interface, choose the add server option as shown in the below diagram.

pgadmin_1.JPG

Step-3

Use the end point and the master user credentials as the connection details.

pgadmin_2.JPG

Step-4

Once connected, we get the following window.

pgadmin_3.JPG