Connect to an instance

Last Updated: Jul 18, 2017

You can connect to an RDS instance through a PostgreSQL client. This article introduces the connection procedure by taking the pgAdmin 4 client as an example.

Background information

Since RDS for PostgreSQL is fully compatible with PostgreSQL, the same method may be used to connect to the database. This article takes the pgAdmin 4 client as an example to connect to an RDS instance. You can refer to this method when using other clients. When you connect to an RDS instance through clients, pay attention to the following information on the selection of the connection address.

  • Use the Intranet address when your client is installed on the ECS that is located in the same region and the same network type with those of the RDS instance to be connected.

  • Use the Internet address for the other situations.

Operation procedure

  1. Add the IP address accessing the RDS instance to RDS white list. For more information on how to set white list, see Set the white list.

  2. Launch the pgAdmin 4 client.

  3. Right click Servers, and then select Create > Server, as shown in the following figure.

    Create server

  4. On the General tab of Create - Server window, enter server name, as shown in the following figure.

  5. Select the Connection tab, enter the information of the instance to be connected, as shown in the following figure.

    Parameters description:

    • Host name/address: refers to the connection address of the RDS instance. If your application accesses the RDS instance by using the Intranet, enter the Intranet address of the RDS instance. If your application accesses the RDS instance by using the Internet, enter the Internet address of the RDS instance. The following procedure shows how to find the connection address and port number of the RDS instance.

      1. Log on to the RDS Console.

      2. Select the region where the target instance is located.

      3. Click the ID of the instance to visit the Basic Information page.

      4. In the Basic Information area, you can find the connection addresses and port numbers of the RDS instance, as shown in the following figure.

    • Port: refers to the port number of the RDS instance. If your application accesses the RDS instance by using the Intranet, enter the Intranet port number of the RDS instance. If your application accesses the RDS instance by using the Internet, enter the Internet port number of the RDS instance.

    • Username: refers to the initial account name of the RDS instance.

    • Password: refers to the password corresponding to the initial account name of the RDS instance.

  6. Click Save.

  7. If the connection information is correct, select Servers > server name > Databases > postgres, and the following interface appears, which indicates that the connection to RDS instance is successful.

    Note: postgres is the defaul system database of the RDS instance. Do not do any operation in this database.

    Connect to RDS instance successfully

Thank you! We've received your feedback.