Skip to main content

How to Create and Manage a PostgreSQL Database in cPanel

You can create and manage PostgreSQL databases directly within the cPanel interface. This process allows you to set up a new database, create a dedicated user, and assign specific permissions to that user for your application.

You can create and manage PostgreSQL databases directly within the cPanel interface. This process allows you to set up a new database, create a dedicated user, and assign specific permissions to that user for your application.

Important: This feature is only available on Hostek plans that support PostgreSQL.

Before you begin

You will need:

  • A cPanel account

  • The name of the database you wish to create

  • A unique username for the database

  • A strong password for the database user

Create a PostgreSQL Database

  1. Log in to your cPanel account.

  2. Locate the Databases section and select MySQL® Databases.

  3. Scroll down to the Create New Database section.

  4. Enter a name for the new database.

  5. Select PostgreSQL as the database type (if available).

  6. Click Create Database.

Create a PostgreSQL User

  1. In the MySQL® Databases interface, scroll to the Add New User section.

  2. Enter a username for the database user.

  3. Enter a password for the user.

  4. Click Create User.

Assign Privileges to the User

  1. Scroll to the Add Account Privileges section.

  2. Select the user you just created from the User dropdown menu.

  3. Select the database you created from the Database dropdown menu.

  4. Check the boxes for the permissions you wish to grant (typically ALL PRIVILEGES for full access).

  5. Click Add.

Confirm the result

  • The new database will appear in the list of available databases.

  • The user will appear in the list of available users.

  • The database will be linked to the user with the permissions you selected.

Limitations

This feature is only available on Hostek plans that support PostgreSQL. If you do not see the option to create a PostgreSQL database or the database type is not listed, your current plan may not include this feature.

Did this answer your question?