Connect with pgAdmin¶
pgAdmin is one of the most popular PostgreSQL clients, useful to manage and query your database.
These are the placeholders you will need to replace in the code sample:
Hostname for PostgreSQL connection, from the service overview page
Port for PostgreSQL connection, from the service overview page
Database Name for PostgreSQL connection, from the service overview page
For this example you’ll need pgAdmin already installed on your computer, for installation instructions follow the pgAdmin website
Connect to PostgreSQL¶
Open pgAdmin and click on Create New Server.
In the General Tab give the connection a Name (e.g.
- In the Connection tab set
Host name/address to
Maintenance database to
In the SSL tab set SSL mode to
Click on Save
Your connection to PostgreSQL should now be opened, with a Dashboard page showing activity metrics on your PostgreSQL database.