Help Center/ Relational Database Service/ User Guide/ Working with RDS for PostgreSQL/ Databases/ Creating a Database
Updated on 2024-10-24 GMT+08:00
View PDF
Share

Creating a Database

Scenarios

After a DB instance is created, you can create databases on it.

Constraints

  • Databases cannot be created for DB instances that are being restored.
  • Database names must be unique.
  • After a database is created, its name cannot be changed.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the instance name.
  5. On the Databases page, click Create Database. In the displayed dialog box, configure required parameters and click OK.

    Figure 1 Creating a database
    • The database name can contain 1 to 63 characters. Only letters, digits, and underscores (_) are allowed. It cannot start with pg or a digit and cannot be the same as RDS for PostgreSQL template database names. RDS for PostgreSQL template databases include postgres, template0, and template1.
    • The default character set is utf-8. You can change it as required.
    • You can specify a template database. A new database will be created using this template. Option template1 (default option) is adapted to RDS and template0 complies with the PostgreSQL community settings.
    • A collation defines how characters are ordered. en_US.UTF-8 is used by default. Different collations may result in varied ordering results. For example, select 'a'>'A'; is false under en_US.UTF-8, but true under 'C', and also, 'C' must be used to obtain the migration results as expected when data is migrated from Oracle to RDS for PostgreSQL. Collations supported by a database can be queried from system catalog pg_collation.
    • Ctype refers to character classification to be used in the new database (LC_CTYPE). The use of this parameter affects the classification of characters, such as lowercase letters, uppercase letters, and digits. By default, the character classification of the template database is used.
    • The remarks can contain 0 to 512 characters.

  6. After the database is created, manage it on the Databases page.
Parent Topic: Databases