Get your first ApsaraDB RDS for PostgreSQL instance running in five steps: create an instance, set up a database and account, configure access control, expose a public endpoint, and connect.
After completing these steps, you have a managed PostgreSQL server with a configured database account, network access restrictions, and a working connection.
Before you begin
Review the Limits that apply to RDS for PostgreSQL instances.
Setup steps
-
Create an ApsaraDB RDS for PostgreSQL instance
Select the instance specifications, storage, and region. The instance is the managed PostgreSQL server that hosts your databases.
-
Create a database and an account
Create a database inside the instance and a database account with the privileges needed to connect and run queries.
-
Configure an IP address whitelist
Add the IP addresses of clients and applications that need to connect. Only whitelisted addresses can reach the instance.
-
Apply for or release a public endpoint
Apply for a public endpoint if you need to connect from outside the Virtual Private Cloud (VPC).
-
Connect to an ApsaraDB RDS for PostgreSQL instance
Connect using a PostgreSQL client or your application. The connection guide covers both the private endpoint (for VPC clients) and the public endpoint (for external clients).
What's next
After completing the setup steps, explore the full set of features available in RDS for PostgreSQL, including extensions and the spatial-temporal engine GanosBase. For more information, see Features.