To simultaneously create a database and the account that will access it, use the PostgreSQL Database Wizard interface. Many web-based applications (for example, bulletin boards, content management systems, and online retail shops) require database access.
(Home >> Databases >> PostgreSQL Database Wizard)
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).
To set up a database, perform the following steps:
In the New Database text box, enter a name for the database and click Create Database.
In the Username text box, enter a name for the user who you wish to allow to manage the database.
Enter and confirm the new password in the appropriate text boxes.
0indicates a weak password, while
100indicates a very secure password.
After you complete the database setup process, select one of the following options:
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: 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).