Update content

How to create a PostGreSQL database

Reviewed on 05 August 2021Published on 05 August 2021

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)
Requirements:
  • You have an account and are logged into the Dedibox Console
  • You have created a webhosting Classic
  • You have 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.

See Also