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 for Windows 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.

Basic Database Operations

In the navigation pane on the left of pgAdmin, right-click the target instance node and choose Create > Database from the shortcut menu.
On the General tab, specify Database and click Save.

Figure 4 Creating a database

Access the created database. In the navigation pane on the left, right-click Tables and choose Create > Table from the shortcut menu.

Create tables in the schema of the database created by the current user.
On the General tab, enter required information and click Save.

Figure 5 Basic information
On the Columns tab, add table columns and click Save.

Figure 6 Adding table columns

On the top menu bar, choose Tools > Query Tool. The SQL CLI is displayed.

Take care when adding, deleting, or modifying data in the instance. Improper operations can cause instance or service exceptions.

Figure 7 SQL execution

Enter an INSERT command and click Execute to insert data into the table.
Figure 8 Inserting data
Enter an SELECT command and click Execute to query data in the table.
Figure 9 Querying data

In the navigation pane on the left, select a database and click the Dashboard tab on the right pane to view database metrics, including Database sessions, Transactions per second, Tuples in, Tuples out, and Block I/O.

Figure 10 Viewing metrics

Cloud Eye monitors operating statuses of DB instances. You can view the DB instance metrics on the management console. For details, see Viewing Monitoring Metrics.

In the navigation pane on the left, right-click the database to be backed up and choose Backup from the shortcut menu.
On the General tab, enter required information and click Backup.
Figure 11 Backing up data

In the navigation pane on the left, right-click the database to be restored and choose Restore from the shortcut menu.
On the displayed tab in the right pane, select a file name and click Restore.
Figure 12 Restoring data

Figure 13 Restoration completed