Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
_Version
_Version

(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 (Home >> Databases >> PostgreSQL Databases).

Set up a database

To set up a database, perform the following steps:

Panel
borderColor#d9d9d9
bgColor#F2F2F2
borderStylesolid

In This Document

Toc no bullet
excludeDocument|Hosting

Related Documentation

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
operatorAND
cqllabel in ("postgresql","databases") and label = "cpanel" and space = currentSpace()
labelsapiguide

For Hosting Providers

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
operatorAND
cqllabel in ("postgresql","databases") and label = "whm" and space in (currentSpace(),"CKB","EA","EA4")
labelsapiguide

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

    Note
    titleNote:

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

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

    Note
    titleNote:

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

  3. Include Page
    _Enter and confirm password and Notes
    _Enter and confirm password and Notes

  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.

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 (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
    titleNote:

    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 (Home >> Databases >> PostgreSQL Databases).