Remotely connect to your PostgreSQL server using pgAdmin4

Now that we have spent a lot of time configuring our server, it's time to use it! We will be reviewing two different ways to connect to our server remotely:

  1. Using pgAdmin4, PostgreSQL's most popular GUI

  2. Using Python API

Database Server Host Name/Address

Your server host name/address can be found on the "Instances" section of AWS. You will need this address to connect to your server.

  1. Click on your PostgreSQL instance

    • Information about your instance should appear below

  2. Copy and save your "Public IPv4 DNS", your server's host name and address

    • Your "Public IPv4 DNS" should be written in the following format: ec2-[your-public-IPv4-address].[region].compute.amazonaws.com"



(1) Better Programming (Medium), How to Provision a Cheap PostgreSQL Database in AWS EC2,

(2) PostgreSQL Tutorial, PostgreSQL Python: Connect to PostgreSQL Database Server,

(3) Towards Data Science (Medium), Python and PostgreSQL: How to Access A PostgreSQL Database Like a Data Scientist,

Last updated