How to create a PostgreSQL database

PostgreSQL is a different DBMS, like MySQL, allowing the management of data. It is released under a BSD license and maintained by a community and not by a company. It is well known for its stability, considered as “near Oracle” and its high respect for SQL standards.

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)

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.