Knowledgebase

PostgreSQL Databases

For cPanel version 11.32

Databases offer a method for managing large amounts of information easily over the web. They are necessary to run many web-based applications such as bulletin boards, content management systems, and online retail shops.

If you need to create a database as well as the account that will access it, we recommend using the PostgreSQL Database Wizard. Alternatively, you may create a database, add users, and link a database to an existing user account using this screen.

1. Create a Database

To create the database:

  1. In the Database Name field, type a name for the database.
  2. Click Create Database.
    • The new database will appear in the Current Databases table.

2. Create a Database User

After you create the database, you will need to add users and their privileges so that the database can be filled and managed. Please note that PostgreSQL user accounts must be created separately from mail and web administrator accounts.

To create a new user account:

  1. To quickly access the PostgreSQL Users interface, click Jump to PostgreSQL Users.
  2. Under Add New User, enter a username.
  3. Enter a password in the Password field.
    • For help generating a strong password, click the Password Generator button.
  4. Retype the password in the Password (Again) field.
  5. Click Create User.

3. Define a User's Privileges

Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.

To define a user’s privileges:

  1. Under Add User to Database, select a user from the User drop-down menu.
  2. From the Database drop-down menu, select the database to which you wish to allow the user access.
  3. Click Submit.

4. The Current Database Table

This table contains a list of databases on your server. For each database, the table displays:

  • The name of the database.
  • The size of the database.
  • Users who may manipulate the database.
  • A link allowing you to delete the database.

5. Search Databases

To search the Current Databases table:

  1. Type your criteria in the Search field.
  2. Click Go.

The table will display the search results.

6. Remove a User From a Database

To disallow a user from managing a database:

  1. Click the Circle_X_button.gif icon next to the user you wish to delete in the Current Databases table.
  2. If you are sure you want to remove the user’s privileges to manage the database, click Yes.

7. Delete a Database

To delete a database from the server:

  1. Locate the row corresponding to the database you wish to delete in the Current Databases table.
  2. Click Delete Database.
  3. If you are sure you want to permanently delete the database, click Yes.

8. Delete a PostgreSQL User

To delete a PostgreSQL user account:

  1. Click Circle_X_button.gif in the appropriate row of the Current Users table.
  2. If you are sure you want to permanently delete the account, click Yes.


To enter new information into a database, you can use the phpPgAdmin client installed with cPanel. For more information regarding phpPgAdmin visit http://phppgadmin.sourceforge.net/.

  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

Accessing cPanel

To access cPanel: Type: http://www.yourwebsite.com.au/cpanel into your preferred Internet...

The cPanel Home Screen

For cPanel version 11.32 The cPanel home screen provides access to all of your cPanel functions....

The Getting Started Wizard

For cPanel version 11.32 Once you have logged in, the start-up wizard is presented. This wizard...

Video Tutorials

For cPanel version 11.32 Clicking this icon will open a web page where various video tutorials...

Accessing Webmail

For cPanel version 11.32 To access webmail: Type: http://www.yourwebsite.com.au/webmail into...