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
  • Install pgAdmin4
  • Connecting to Server

Was this helpful?

  1. Remote Server: Accessing Server on Local Computer

Connect with pgAdmin4

Connecting to your PostgreSQL server hosted on AWS on your local pgAdmin4

PreviousOverviewNextConnect with Python API

Last updated 4 years ago

Was this helpful?

Install pgAdmin4

To install pgAdmin4 on your local computer, follow the directions here:

Connecting to Server

  • Open pgadmin4 on your local computer

  • Select "Object"

  • Under "Objects", go to "Create" and then select "Server"

  • OPTION 2: You can also click "Add New Server" in the "Quick Links" menu in the Dashboard

  • Under "General"

    • Name: Write any name you'd like for your server to be on your local computer: EX. PostgreSQL AWS

  • Under "Connection"

    • Host name/address: Paste your host name we copied from our AWS instance (discussed further in the Overview section of this chapter)

    • Port: 5432 (standard for PostgreSQL)

    • Username: your "username" created in the "Add Role to PostgreSQL Server" section in previous chapter

    • Password: type "password" for your "username"

    • Save password?: Select if you prefer not to type your password every time you log into the server locally

  • Press the "Save" icon at the bottom right corner of the dialog box

You've now connected to your server!

Download
Logo