Connect with pgAdmin

pgAdmin is one of the most popular PostgreSQL clients, useful to manage and query your database.

Variables

These are the placeholders you will need to replace in the code sample:

Variable

Description

HOSTNAME

Hostname for PostgreSQL connection, from the service overview page

PORT

Port for PostgreSQL connection, from the service overview page

DATABASE

Database Name for PostgreSQL connection, from the service overview page

PASSWORD

avnadmin password, from the service overview page

Pre-requisites

For this example you’ll need pgAdmin already installed on your computer, for installation instructions follow the pgAdmin website

Connect to PostgreSQL

  1. Open pgAdmin and click on Create New Server.

  2. In the General Tab give the connection a Name (e.g. MyDatabase)

  3. In the Connection tab set
    • Host name/address to HOSTNAME

    • Port: to PORT

    • Maintenance database to DATABASE

    • Username to avnadmin

    • Password to PASSWORD

  4. In the SSL tab set SSL mode to Require

  5. Click on Save

Your connection to PostgreSQL should now be opened, with a Dashboard page showing activity metrics on your PostgreSQL database.

Screenshot of a pgAdmin Dashboard window