pgAdmin

pgAdmin#

pgadmin is a client that Postgres provides to administer, manage, and query the database ( in our case, the database we created in RDS). There are other softwares that you can use, like the toad.

Install pgAdmin from here. You can download and use pgAdmin without having a local instance of PostgreSQL on your client computer (that’s your laptop).

../_images/pg1.png
../_images/pg2.png

Note

If you are setting up the pgadmin for the first time, then you need to set up a master password. So please don’t skip that popup.

You need endpoint and port.

Hint

Here, the endpoint and port from AWS RDS is mentioned in the RDS creation instruction.

../_images/pg3.png

Here enter the hostname and password of your RDS instance.

../_images/pg4.png
../_images/pg5.png

Attention

You will see one active connection to your database from your AWS console if you want to confirm.

../_images/pg6.png
  • How to use it?

Here is the query tool that you can use to query your database.

../_images/pg7.png

Now you successfully connected the database in the cloud to your pgadmin client. So whatever query you run here will be running in the cloud.

../_images/connectionb3.png