Create a database on an ApsaraDB RDS for PostgreSQL instance using the RDS console or by running a SQL statement. To automate database creation at scale, use the CreateDatabase API operation.
Prerequisites
Before you begin, ensure that you have:
An ApsaraDB RDS for PostgreSQL instance. If you don't have one, create an instance first.
Constraints
Database names cannot be changed after creation.
The character set cannot be changed after creation. Choose carefully before clicking Create.
To migrate data from an on-premises database, create the database and an account on the RDS instance in advance. Make sure the database has the same properties as the on-premises database and the account has the same permissions.
Create a database using the console
Go to the Instances page. In the top navigation bar, select the region where your instance resides. Find the instance and click its ID.
In the left-side navigation pane, click Databases.
Click Create Database.
Configure the following parameters.
Parameter Required Description Database Name Yes The name of the database. The name must be up to 63 characters in length and can contain lowercase letters, digits, hyphens (-), and underscores (_). It must start with a lowercase letter and end with a lowercase letter or a digit. Supported Character Set Yes The character set for the database. This cannot be changed after the database is created. Collate No The collation rule for sorting strings. Ctype No The character type supported by the database. Authorized By No The owner of the database. The owner has all permissions on the database. Description No An optional description for the database. Click Create.
The new database appears on the Databases page. 
The Databases page also shows the following read-only fields after creation.
| Field | Description |
|---|---|
| ConnLimit | The maximum number of concurrent requests allowed for the database. Unlimited by default. To change this value, log in to the database with a privileged account and run: ALTER DATABASE <database_name> CONNECTION LIMIT |
| Tablespace | The tablespace the database belongs to. Defaults to pg_default. Tablespace paths cannot be viewed or modified. If you migrated data from a self-managed database, the tablespace name on the RDS instance matches the source. You can change the name of the tablespace to which a database or a table belongs to pg_default. For more information, see Use the cloud migration feature for an ApsaraDB RDS for PostgreSQL instance. |
Create a database using SQL
Connect to the RDS for PostgreSQL instance using a CLI or client tool.
Run the following statement.
CREATE DATABASE <database_name>;
API reference
| API operation | Description |
|---|---|
| CreateDatabase | Creates a database on an RDS for PostgreSQL instance. |