title: PostgreSQL Database Wizard created at: Sat Oct 19 2024 15:43:23 GMT+0000 (Coordinated Universal Time) updated at: Sat Feb 08 2025 14:22:02 GMT+0000 (Coordinated Universal Time) --- # 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*](https://docs.cpanel.net/cpanel/databases/postgresql-databases) interface (*cPanel » Home » Databases » PostgreSQL Databases*). > \[!WARNING] > Important > This interface **only** appears in your cPanel account if your hosting provider installs and configures PostgreSQL in WHM’s [*Configure PostgreSQL*](https://docs.cpanel.net/whm/database-services/configure-postgresql/) interface (*WHM » Home » Database Services » Configure PostgreSQL*). # Set up a database > \[!NOTE] > 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 whom you wish to allow to manage the database. 3. Enter and confirm the new password in the appropriate text boxes. > \[!NOTE] > Note > 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 & Security* to generate a strong password. For more information, read our [Password & Security](https://docs.cpanel.net/cpanel/preferences/password-and-security) documentation. 1. Click *Create User.* 2. 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 has 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 Database User* — Click to open the [*PostgreSQL Databases*](https://docs.cpanel.net/cpanel/databases/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] > Note\ > When you use the *PostgreSQL Database Wizard* interface 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* section in the [*PostgreSQL Databases*](https://docs.cpanel.net/cpanel/databases/postgresql-databases) interface (*cPanel » Home » Databases » PostgreSQL Databases*).