Overview

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"

References

Guides

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

https://medium.com/better-programming/how-to-provision-a-cheap-postgresql-database-in-aws-ec2-9984ff3ddaeamedium.com

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

https://www.postgresqltutorial.com/postgresql-python/connect/www.postgresqltutorial.com

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

Python and PostgreSQL: How To Access A PostgreSQL Database Like A Data ScientistMedium