Docs

RDS for PostgreSQL

Managing databases

Creating a database

Creating a database

To use RDS for PostgreSQL, you need to create databases in your instance. This topic describes how to create a database for PostgreSQL instance.

Precautions

A maximum of 2000 databases can be created under one instance.

Prerequisites

You have Creating an instance, and the instance is in the Running status.

Procedure

Login to the RDS for PostgreSQL console.

In the upper-left corner of the top menu bar, select the project and region for the instance.

tip

If the project of the instance has not been set, the project should be selected as All resources.

Click on Instances in the left navigation bar.

On the Instances page, click on the target instance name to enter the instance details page.

At the top of the page, click Databases.

On the Databases tab, click Create database, and in the dialog box that pops up, set the following parameters.

Parameter	Description
Database name	Fill in the database name. The naming rules are as follows: The name is unique within the instance. 2 to 63 characters in length. Must start with a letter and end with a letter or a digit. Can contain letters, digits, underscores (_) and hyphens (-). Some reserved words or keywords cannot be used in the database name, see Reserved keywords for all reserved keywords.
Character set	Select UTF8, Latin1, or ASCII.
Collate	String collation.
Ctype	Character set
Database owner	Select an account to be the owner of the database. This parameter is optional. You can also modify the database authorized by the account after the creation is complete. tip Instance read-only accounts, high-privilege accounts with DDL privileges disabled, or normal accounts with DDL privileges disabled cannot be used as database owners.

Click OK to complete database creation.

Last updated: 2025.11.17 16:15:06