How to Create PostgreSQL Databases in China? (Step-by-Step Guide)
How to Create PostgreSQL Databases in China? (Step-by-Step Guide)

TLDR; This PostgreSQL China tutorial provides you with a step-by-step solution to create and host a PostgreSQL Database in China.


What is PostgreSQL?

PostgreSQL is older but very powerful open source relational database. PostgreSQL supports most of the SQL standards and provides many other modern features such as complex queries, foreign keys, triggers, views, transaction integrity, and so on. Generally it is loved by developers of startups around the world.

21YunBox provides a fully managed (free of operations and maintenance) PostgreSQL database solution for China.


How to Create a PostgreSQL Database in China?

  1. Sign-up on 21YunBox
  2. Select “Database” in the console
  3. Then click “Add Database”
  4. Use the following values during creation
Options Explanation
Database. Give the currently created database instance a name
Database name. The name of the database when connecting to the database. If not specified, the system will automatically generate it.
Database Username The username of the database when connecting to the database. If not specified, the system will automatically generate it.

Note: Database name and Database user name cannot be changed once created.

You will find that in the above configuration, the database password is not filled in. This is because the system will automatically generate it and no additional filling is required.

Create a PostgreSQL database showing a configuration screenshot
Create a PostgreSQL database showing a configuration screenshot

If you are not sure how to do it, you can see an example in the video below:

How to create a PostgreSQL database operation example


How to Remotely Connect to the Database?

In most cases, we connect to the database to: add, delete, modify or search and other actions that are connected by code. We have automatically spliced the URL connected to the database, to complete the configuration, you only need to paste it .


How to Connect to the Database Under the Intranet?

Under the intranet of 21YunBox, you can directly use database URL to connect.

For details, please refer to the database connection section:

Screenshot of PostgreSQL after creation
Screenshot of PostgreSQL after creation


How to connect to a Database Under the External Network?

Under 21YunBox’s external network, you can use the client visual interface tools such as DBeaver, or Postico, or directly use command line to connect.

If you are not sure what to do, please watch the following video:

  1. Use DBeaver to connect to the database:
Use DBeaver to connect to the database
  1. Use the command line to connect to the database:
Use the command line to connect to the database


How to Backup the Database?

21YunBox provides 7 days of free cloud database backup, which is rolled daily and stored in a multi-backup cloud disk in .dump format.

An example of a PostgreSQL backup file after creation
An example of a PostgreSQL backup file after creation



Ready to make your app work in China?

Get Started Questions? Talk to an expert.