Managing databases may sound complex, but cPanel’s PostgreSQL Database Wizard simplifies the entire process. This tool is especially useful for Govaio.com customers who want to quickly set up a PostgreSQL database along with the required user accounts and privileges.

Whether you're launching a new blog, eCommerce store, or a custom-built web application, PostgreSQL is a powerful and reliable database system that you can manage efficiently using the Wizard tool built into cPanel.

✅ This article is written exclusively for Govaio.com customers.

📘 What Is the PostgreSQL Database Wizard?

The PostgreSQL Database Wizard is a cPanel tool designed to guide users through the process of:

1. Creating a PostgreSQL database
2. Creating a user to access that database
3. Assigning the user to the database with appropriate privileges

It’s a streamlined version of the manual process and is highly recommended for beginners or anyone looking to save time.

✅ Why Use PostgreSQL and the Wizard Tool?

PostgreSQL is a robust, enterprise-grade relational database system known for its:

• Standards compliance (SQL:2011)
• Support for JSON, XML, and custom data types
• Advanced indexing and search capabilities
• Stability and performance

🔍 Benefits of Using the Wizard Interface:

• Step-by-step guidance
• Reduces setup errors
• Ensures user and database are correctly linked
• No coding or command-line experience needed

Perfect for Govaio users hosting:

• CMS platforms (e.g., Drupal with PostgreSQL support)
• Custom apps (Python, PHP, Node.js)
• Forums, blogs, or eCommerce systems

🛠️ How to Use the PostgreSQL Database Wizard in cPanel

Let’s walk through the process of setting up your PostgreSQL database using the Wizard:

📌 Step 1: Log into cPanel

1. Visit your Govaio hosting control panel.
2. Enter your cPanel username and password.
3. Scroll to the Databases section.
4. Click on PostgreSQL Database Wizard.

📌 Step 2: Create a New Database

1. On the first page, you’ll be asked to enter a name for your new database.
   • Example: shop_data, cms_content, or project_app
2. Click Next Step.

✅ Tip: Keep the name short but descriptive. It helps you identify its purpose later.

📌 Step 3: Create a Database User

1. You’ll now create the user account that will access the database.
2. Enter:
   • A username (e.g., admin_user)
   • A strong password (use the built-in generator for best security)
3. Confirm the password and click Create User.

✅ Govaio security tip: Use passwords with upper/lowercase letters, numbers, and special characters.

📌 Step 4: Assign User Privileges

After the user is created, the Wizard takes you to the privilege assignment screen.

1. Select ALL PRIVILEGES to give full access to the user.
   • This is typical for web apps that need to read, write, and update data.
2. Alternatively, assign only what’s needed:
   • SELECT, INSERT, UPDATE, DELETE, etc.
3. Click Next Step to finalize the setup.

🎉 That’s it! Your database, user, and permissions are all ready to use.

🔌 Connecting Your Application to the Database

Once your database is created, you’ll need to use the following credentials in your application:

• Database name: the name you created
• Username: the database user you created
• Password: the password you chose
• Host: Usually localhost or your Govaio server IP
• Port: Default PostgreSQL port is 5432

Example: PHP PDO Connection

$dsn = 'pgsql:host=localhost;port=5432;dbname=mydb;';

$user = 'myuser';

$password = 'mypassword';

try {    

$dbh = new PDO($dsn, $user, $password);

 echo "Connected to PostgreSQL!";

} catch (PDOException $e) 

{    echo $e->getMessage();

}

🔄 How to Modify or Delete Databases Created with the Wizard

Even after using the Wizard, you can still manage your database and user via the PostgreSQL Databases interface in cPanel.

Modify Privileges:

1. Go to cPanel > PostgreSQL Databases.
2. Scroll to Current Databases.
3. Click Privileges next to your user.

Delete a Database or User:

1. Use the Delete option next to the database or user.
2. Confirm the deletion carefully—this action is irreversible.

🧰 Troubleshooting Common PostgreSQL Wizard Issues

❌ Error: "User already exists"

Try using a different username.

Check the PostgreSQL Databases interface to see if the user was already created.

❌ Error: "Database already exists"

• cPanel prevents duplicate names. Use a variation like blog_db1, project2025, etc.

❌ App not connecting to DB

• Double-check your:
  • Host (try localhost)
  • Port (should be 5432)
  • Password and user access
• Ensure user has correct privileges.

❌ "Access Denied" when remote connecting

• By default, PostgreSQL on shared hosting blocks external connections.
• On Govaio VPS or dedicated servers, you can:
  • Enable remote access via firewall rules
  • Modify pg_hba.conf and postgresql.conf (root access required)

🔐 Security Best Practices for PostgreSQL Users

• 🔒 Use strong passwords
• 🔒 Limit privileges to only those needed
• 🔒 Delete unused users and databases
• 🔒 Keep your web apps up to date (to prevent SQL injection attacks)

📦 How to Backup Your PostgreSQL Database

Option 1: Use cPanel Backup

1. Go to cPanel > Backup or Backup Wizard.
2. Download Partial Backups > PostgreSQL Databases.

Option 2: Use phpPgAdmin

1. Go to cPanel > phpPgAdmin.
2. Select your database > Click Export.
3. Choose SQL format and download.

🤔 Frequently Asked Questions

❓ Can I use the Wizard to add users to an existing database?

No, the Wizard is only for new database + user setups. Use PostgreSQL Databases for managing existing ones.

❓ How many databases can I create?

Depends on your Govaio hosting plan. Shared plans have limits; VPS and dedicated plans typically offer unlimited DBs.

❓ Is PostgreSQL faster than MySQL?

It depends on use case. PostgreSQL is often better for complex queries, indexing, and enterprise apps, while MySQL may be faster for simple read-heavy apps.

The PostgreSQL Database Wizard in cPanel is the easiest and safest way to set up a working database with user permissions on Govaio.com. It’s perfect for beginners and ensures that your application has the right backend structure from the start.

By following the steps in this guide, you can:

Set up a working database environment in under 5 minutes

Avoid permission errors and configuration issues

Get your project up and running quickly

✅ This guide is tailored specifically for Govaio.com users.