nav-img
Advanced

Connecting to an RDS for PostgreSQL Instance

You can connect to an RDS for PostgreSQL instance through a command-line interface (CLI), graphical user interface (GUI), or using Java database connectivity (JDBC).

Table 1 Connection methods

Connection Method

Description

In Linux, you need to install a PostgreSQL client on the ECS and connect to the instance through the psql CLI over a private or public network.

  • A private IP address is provided by default.

    When your applications are deployed on an ECS that is in the same region and VPC as the RDS for PostgreSQL instance, you are advised to use a floating IP address to connect to the instance through the ECS.

  • If you cannot access your RDS for PostgreSQL instance through a floating IP address, bind an EIP to the instance and connect to the instance through the EIP.

In Windows, you can use the pgAdmin client to connect to an RDS for PostgreSQL instance.

If you are connecting to an instance through JDBC, the SSL certificate is optional. For security reasons, you are advised to download the SSL certificate to encrypt the connection.