You can connect to an instance through a pgAdmin client for visualized operation.
² Note
You need to use pgAdmin 4 and above.
Procedure
² Note
This section uses the pgAdmin4 v6.5 version for demonstration. The specific operation steps may vary from version to version.
1. Start the pgAdmin client.
2. Right-click on Server and go to Create > Server to create a connection.
3. In the General tab of the pop-up box, fill in some description information of the connection, such as the name. In the Connection tab, fill in the network information (the information for the RDS-PostgreSQL instance) for the connection.
4. Save the configuration. If the connection information is correct, double-click the newly created server to connect to the instance.
Explanation of Key Parameters in the Connection Tab
Host name/address: Enter the IP address in the VIP/IPv4 connection address of the instance when using an Intranet for connection; and enter the elastic IP address bound by the target instance when using a public network for connection.
Port: The database port, defaults to 5432.
Username: The user name, defaults to root.
Password: The password corresponding to the Username.