You can connect to an instance through a pgAdmin client for visualized operation.
Procedure
² Note
• You need to use pgAdmin 4 and above.
• This section uses the pgAdmin4 6.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.
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.
4. Save the configuration. If the connection information is correct, double-click the newly created server to connect to the instance.