Updated on 2023-07-06 GMT+08:00

Overview

This section describes how to create a PostgreSQL DB instance on the management console and bind an EIP to the DB instance to make the instance publicly accessible.

If you are using RDS for the first time, see the constraints described in section PostgreSQL Constraints.

Process

Figure 1 illustrates the process of connecting to a PostgreSQL DB instance through a public network.

Figure 1 Connecting to a DB instance through a public network
  • Step 1: Create a DB instance. Confirm the specifications, storage, network, and database account configurations of the PostgreSQL DB instances based on service requirements.
  • Step 2: Bind an EIP. The EIP provides independent public IP addresses and bandwidth for Internet access. You can apply for an EIP on the VPC console and bind the EIP to the RDS DB instance.
  • Step 3: Configure security group rules. To access a DB instance from resources outside the security group, you need to configure an inbound rule for the security group associated with the DB instance.
  • Step 4: Connect to a DB instance through psql. You can connect to a DB instance through a common connection or an SSL connection. The SSL connection encrypts data and is more secure.