We have a new documentation site for cPanel & WHM! You can find our new documentation site at docs.cpanel.net.

We will continue to maintain our API documentation on this server.

Version 72 Documentation
Child pages
  • PostgreSQL Database Wizard
For cPanel & WHM version 72
Skip to end of metadata
Go to start of metadata

(cPanel >> Home >> Databases >> PostgreSQL Database Wizard)

Overview

This wizard guides you through the setup of a PostgreSQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. To create additional databases or users, use the PostgreSQL Databases interface (cPanel >> Home >> Databases >> PostgreSQL Databases).

Set up a database

Note:

The maximum length of a database name or username is 63 characters. If your hosting provider enabled database prefixing, this length includes the database prefix and underscore character (_).

To set up a database, perform the following steps:

  1. In the New Database text box, enter a name for the database and click Create Database.

  2. In the Username text box, enter a name for the user who you wish to allow to manage the database.

  3. Enter and confirm the new password in the appropriate text boxes.

    Notes:

    • The system evaluates the password that you enter on a scale of 100 points. 0 indicates a weak password, while 100 indicates a very secure password.
    • Some web hosts require a minimum password strength. A green password Strength meter indicates that the password is equal to or greater than the required password strength.
    • Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.

  4. Click Create User.
  5. Review the User and Database names and click Submit to add the new user to the new database.

The system displays a message that states that the system set up the database and user account successfully.

In This Document

Related Documentation

Content by label

There is no content with the specified labels

For Hosting Providers

Content by label

There is no content with the specified labels

Additional options

After you complete the database setup process, select one of the following options:

  • Add another database — Click to return to the start of the PostgreSQL Database Wizard to add more databases.

  • Add another PostgreSQL Databases User — Click to open the PostgreSQL Databases interface (cPanel >> Home >> Databases >> PostgreSQL Databases) to create additional user accounts and assign them to a database.

  • Return to Home — Returns you to the cPanel Home interface.

    Note:

    When you use the PostgreSQL Database Wizard to add a user and a database, the system automatically grants the user access to the database. You do not need to use the Add User to Database feature in the PostgreSQL Databases interface (cPanel >> Home >> Databases >> PostgreSQL Databases).