Suggest an edit

How to create a PostgreSQL database

Reviewed on 12 February 2024Published on 05 August 2021

This documentation describes the usage of a previous web hosting offer proposed by
Refer to the Scaleway Web Hosting documentation for information about the current web hosting product.

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.

    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
How to manage a MySQL database with phpMyAdminHow to change the password of a PostgreSQL database
Docs APIScaleway consoleDedibox consoleScaleway LearningScaleway.comPricingBlogCarreer
© 2023-2024 – Scaleway