Connecting to your PostgreSQL server hosted on AWS on your local pgAdmin4
To install pgAdmin4 on your local computer, follow the directions here:
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!
Last updated 5 years ago
