Before you start to use your ApsaraDB RDS for PostgreSQL instance, you must create databases on the RDS 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 data that is stored in an organized manner and can be shared by a number of users. A database provides the minimal redundancy and is independent of applications. In simple words, a database is a data 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
- If the RDS instance uses standard or enhanced SSDs, you can create and manage databases in the ApsaraDB RDS console.
- If the RDS instance uses local SSDs, you can create and manage databases by using SQL statements.
- If you want to migrate data from an on-premises database to the RDS instance, you must create a database and an account on the RDS instance. The created database must have the same name as the on-premises database. The created account must have the same name as the account that is authorized to manage the on-premises database.
Create a database for an RDS instance with standard or enhanced SSDs
Create a database for an RDS instance with local SSDs
What to do next
Connect to the RDS instance. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.