PostgreSQL Databases

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Overview

Use this interface to create, manage, and delete PostgreSQL® databases and database users.

Create a database

To create the database, perform the following steps:

  1. In the Database Name text box, enter a name for the database.

  2. Click Create Database.

  3. Click Go Back. The new database will appear in the Current Databases table.

Current Databases

The Current Databases table lists the following information for each database in your account:

  • Database — The name of the database.

  • Size — The size of the database.

  • Privileged Users — Users who can manipulate the database.

  • Actions — Click the appropriate icon in this column to perform an action on the corresponding user or database.

Remove a user

To remove a user from a database, perform the following steps:

  1. In the Current Databases table, click Delete next to the user that you want to delete.

  2. To remove the user’s privileges to manage the database, click Yes.

Rename a database

To rename a database, perform the following steps:

  1. Click Rename in the Actions column next to the database that you wish to rename.

  2. Enter the new database name in the New name text box.

  3. Click Proceed.

Delete a database

To delete a database, perform the following steps:

  1. Click Delete in the Actions column next to the database that you wish to delete.

  2. To permanently delete the database, click Delete Database.

Add a PostgreSQL user

After you create the database, add users to the database.

To create a new user account, perform the following steps:

  1. Enter a username in the Username text box.

    2. Enter and confirm the new password in the appropriate text boxes.

    3. Click Create User.

Add a user to a database

To add a user to a database, perform the following steps:

  1. Select the appropriate user and the database you want to add the user to from the User and Database menus.

  2. Click Submit.

Current Users

The Current Users table lists all of your PostgreSQL users. Use the functions in this table to change user passwords and usernames, or to delete users.

Change a PostgreSQL user password

To change a PostgreSQL user’s password, perform the following steps:

  1. In the Current Users table, click Change Password in the Actions column next to the user that you wish to change.

  2. Enter and confirm the new password in the appropriate text boxes.

     3. Click Change Password.

Change a PostgreSQL user name

To change a PostgreSQL user’s username, perform the following steps:

  1. Click Rename in the Actions column for the user that you wish to rename.

  2. Enter the new username for the account in the New name text box.

  3. Click Proceed.

Delete a PostgreSQL user

To delete a PostgreSQL user account, perform the following steps:

  1. Click Delete in the row next to the user that you wish to delete.

  2. To permanently delete the account, click Remove User.

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Email

Email Deliverability in cPanel

Use this interface to identify problems with your mail-related DNS records for one or more of your domains. The system uses these records to verify that other servers can trust it as a sender.

Virus Scanner

Overview The Virus Scanner interface scans your cPanel account for security threats. If ClamAV® Virus Scanner identifies a security threat, the system prompts you to perform an

Do You Want To Boost Your Website?

Share your requirements with us and we will get in touch with you shorlty.

ask
anything...

Get in touch