The pgAdmin server

We can connect the RDS to pgAdmin by performing the following steps: 

1. From the pgAdmin 4.5 main browser, right-click on Servers. Then, select Create and click on Server...; the Create - Server popup will display, as follows:

Figure 2.16 – The Create - Server popup

2. Type the name ATM RDS into the Create - Server popup. Then, select the Connection tab, as shown in Figure 2.17:

Figure 2.17 – PostgreSQL Connection

3. Within the Connection tab shown in the preceding screenshot, enter your PostgreSQL RDS details:

• Host name/address (your RDS endpoint): atm.ck5074bwbilj.us-east-1.rds.amazonaws.com
• Username (your RDS master username): dba
• Password (your RDS password): bookdemo

Once these details have been entered, click on Save.

4. Expand the servers in your pgAdmin by clicking on the > button on the left-hand side, and then you can connect to the ATM RDS by simply double-clicking...