How to create a PostgreSQL database

PostgreSQL is an object-relational database management system that uses the SQL language. It is open source and well known for its stability, reliability and strong community.

Compared with MySQL, PostgreSQL has the following advantages:

• Better compliance with SQL standards,
• Stricter data integrity,
• More native data types,
• Much more customizable/extensible (define custom data types and functions),
• More advanced support of transactions, stored procedures, triggers, and views,
• Asynchronous notifications and treatments,
• Better scalability.

However, it has the following limitations:

• More complex to understand,
• Replication is harder to implement,
• Generally less well-supported than MySQL in current projects (CMS, for example).

Before you start

To complete the actions presented below, you must have:

• A Dedibox account logged into the console
• Created a Webhosting Classic
• Created a PostgreSQL database

1. From your Dedibox console, click Hosting. A list of your webhosting accounts displays.
2. Click Manage next to the hosting you want to configure. The webhosting overview page displays.
3. Click PostgreSQL databases in the side menu. The list of your databases displays.
4. Click Add database. A pop-up displays.
5. Enter the database name, the database password, and its confirmation. Then click Create PostgreSQL database.
   Tip

   For a strong password, combine lowercase, uppercase, numbers, and special characters.

Your database is being created and displays in the list of your PostgreSQL databases.