This section describes how to operate the database using the tool pgAdmin.
pgAdmin is an open-source tool for designing, maintaining, and managing RDS-PostgreSQL.
You can connect to an RDS-PostgreSQL instance through the visualization operation of the pgAdmin client.
This section uses the pgAdmin v6.20 for demonstration. The specific operation steps may vary from version to version.
Making Preparations
1. Prepare a device that can access the RDS-PostgreSQL instance.
2. Bind the network address to the RDS-PostgreSQL instance and make sure that local devices can access the network to which a relational database instance is bound.
3. On the device that can access the RDS-PostgreSQL instance, install the pgAdmin client.
Procedure
1. Launch pgAdmin and enter the password to log in.
2. Click Servers in the Browser on the left and right-click Register > Server...
3. On the pop-up page, fill in the name of the database instance in the General column and fill in the connection information of the database instance in the Connection column, mainly including the following items: Host name/address: fill in the instance connection address IP (bound elastic IP); Port: fill in the instance connection port; Maintenance database: fill in the maintenance database, that is, the default database used to connect to the instance, generally postgres; Username: the name of the user connected to the instance; and Password: fill in the user Password. Other columns such as Parameters, SSH Tunnel, and Advanced are optional items that do not affect normal connections.
4. After filling in, click Save to save the above information. If no error is reported, it means that the configuration is successful.