How to Use the PostgreSQL® Database Wizard in cPanel

Introduction

The PostgreSQL® Database Wizard in cPanel simplifies the process of setting up a PostgreSQL database and user by combining the steps into one easy flow. If you’re planning to use PostgreSQL for your website or application, the wizard is the fastest and most beginner-friendly way to get started.

This guide walks you through how to use the wizard to create a fully functional PostgreSQL database.

Step-by-Step: Create a PostgreSQL Database with the Wizard

1. Log in to cPanel

• Go to your hosting account and access the cPanel dashboard.

2. Open the Wizard

• Scroll down to the Databases section

• Click on PostgreSQL® Database Wizard

3. Step 1: Create a Database

• Enter a name for your new database (e.g., my_app_data)

• Click Next Step

The wizard will now create your PostgreSQL database.

4. Step 2: Create a Database User

• Enter a username for the database user (e.g., user1)

• Set a strong password (or use the Password Generator)

• Confirm the password

• Click Create User

This user will be used by your application to connect to the database.

5. Step 3: Assign User to Database

• You will now assign the user to the database you just created

• Select the privileges you want to grant (most applications require ALL PRIVILEGES)

• Click Next Step

The wizard will apply the selected permissions.

6. Done!

You will now see a confirmation message that:

• Your database has been created

• The user has been added

• The privileges have been set

You’re now ready to use this database in your application or manage it with phpPgAdmin.

What’s Next?

• Use phpPgAdmin (found in cPanel) to manage tables and data

• Store your database credentials securely for future reference

• Connect your website or software to the database using the credentials you just created

Tips for Security & Performance

• Always use strong, unique passwords

• Avoid using common names like admin or test for databases and users

• Remove unused databases and users to reduce risk

• Back up your PostgreSQL database regularly using phpPgAdmin

Conclusion

The PostgreSQL® Database Wizard in cPanel streamlines the entire process of creating a database, user, and assigning privileges—all in just a few clicks. It's the ideal tool for anyone needing to quickly set up a PostgreSQL environment for websites, apps, or custom development.