Before you can use an ApsaraDB RDS instance, you must create a database on the instance. This topic describes how to create a database on an ApsaraDB RDS for PostgreSQL instance.

Terms

  • Instance: a virtualized database server, on which you can create and manage a number of databases.
  • Database: a set of organized data that can be shared by a number of users. A database provides the minimal redundancy and is independent of applications. You can consider a database to be a warehouse that is used to store data.
  • Character set: a collection of letters, special characters, and encoding rules that are used in a database.

Precautions

  • You can create and manage RDS instances in the ApsaraDB RDS console.
  • Before you can migrate data from an on-premises database to an RDS instance, you must create a database and an account on the RDS instance. Make sure that the created database has the same properties as the on-premises database. In addition, make sure that the created account has the same permissions on the created database as the account that is authorized to manage the on-premises database.

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Databases.
  3. Click Create Database.
  4. Configure the following parameters.
    Parameter Description
    Database Name
    • The name of the database can contain up to 63 characters in length.
    • The name of the database can contain lowercase letters, digits, hyphens (-), and underscores (_).
    • The name of the database must start with a lowercase letter and end with a lowercase letter or a digit.
    Supported Character Set The character set that is supported by the database.
    Collate The rule based on which strings are sorted.
    Ctype The type of character supported by the database.
    Authorized Account: The owner of the database. The owner has all permissions on the database.
    Description The description of the database.
  5. Click Create.

What to do next

Connect to the RDS instance. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.