Connecting to an RDS for PostgreSQL Instance Using pgAdmin

pgAdmin is an administration and development tool for PostgreSQL. Using pgAdmin, you can connect to specific databases from your clients, create tables, and run simple and complex SQL statements. pgAdmin can be used on Windows, Linux, macOS, and other operating systems. The latest version of pgAdmin is based on the browser/server (B/S) architecture. For more information, see the pgAdmin documentation.

This section uses pgAdmin 4-4.17 as an example to describe how to use pgAdmin to connect to an RDS for PostgreSQL instance and create databases and tables.

The pgAdmin version must be 4 or later.

Procedure

Obtain the pgAdmin installation package.

Download the pgAdmin installation package from the pgAdmin official website.
Double-click the installation package and complete the installation as instructed.
Start the pgAdmin client after the installation.
In the displayed login window, right-click Servers and choose Register > Server from the shortcut menu.

Figure 1 Login information
On the General page, specify Name. On the Connection page, specify information about the DB instance to be connected. Then, click Save.

Figure 2 Entering basic information

Figure 3 Entering connection information

Parameter description:
- Host name/address: indicates the EIP bound to the target DB instance.
- Port: indicates the database port. By default, the value is 5432.
- Username: indicates the username. By default, the value is root.
- Password: indicates the password of the target database username.
In the login window, check that the connection information is correct. The target DB instance is successfully connected.