Create a PostgreSQL Server Using AWS EC2
  • Introduction
  • AWS EC2: Launching Instance
    • Overview
    • Create Security Group
    • Create Launch Template
    • Option 1: Create Auto Scaling Group
    • Option 2: Create a Single Instance
    • Attach Elastic IP Address
  • Ubuntu 20.04: Configuring PostgreSQL
    • Overview
    • Install PostgreSQL
    • Add Role to PostgreSQL Server
    • Allow Remote Connection
  • Remote Server: Accessing Server on Local Computer
    • Overview
    • Connect with pgAdmin4
    • Connect with Python API
  • AWS EC2: Backup Server
    • Overview
    • Configuring Automatic Backups
  • Next Steps
Powered by GitBook
On this page
  • Database Server Host Name/Address
  • References

Was this helpful?

  1. Remote Server: Accessing Server on Local Computer

Overview

Remotely connect to your PostgreSQL server using pgAdmin4

PreviousAllow Remote ConnectionNextConnect with pgAdmin4

Last updated 4 years ago

Was this helpful?

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,

(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,

https://www.postgresqltutorial.com/postgresql-python/connect/www.postgresqltutorial.com
Python and PostgreSQL: How To Access A PostgreSQL Database Like A Data ScientistMedium
Logo
https://medium.com/better-programming/how-to-provision-a-cheap-postgresql-database-in-aws-ec2-9984ff3ddaeamedium.com