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:
Using pgAdmin4, PostgreSQL's most popular GUI
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.
Click on your PostgreSQL instance
Information about your instance should appear below
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,
(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
