How To Manage PostgreSQL Databases

July 5, 2023 / MySQL

In this article, we will explain how to manage PostgreSQL databases. If you are looking to manage your PostgreSQL database users, then visit to this article.

Once you have created a database user, now that you are prepared, create a database and link the user to it:

Create a database

  1. Login to your “cPanel Account”.
    Login to cPanel Account
  2. Search for the “Databases” section, and click on the “PostgreSQL Databases”.
    PostgreSQL Databases
  3. Under “Create New Database”, type the name of the database, and click on “Create Database”.
    Create Database

Add a user to a database

  1. Login to your “cPanel Account”.
  2. Click on the “PostgreSQL Databases” from the Search tool.
  3. Under “Add User to Database”, select the “user” and the “database” that you want to add.
    Add User To Database
  4. Click on “Submit”.

Remove a user from a database

  1. Log into “cPanel”.
  2. Click on the “PostgreSQL Databases”.
  3. Under “Current Database”, select the user that you want to remove and click the “Delete icon”.
    Trash the user

Delete a “Database”.

Remember: –
Before deleting a database, make sure that you have a backup copy.

  1. Log into your “cPanel Account”.
  2. Select “PostgreSQL Databases” tool.
  3. Under Current Databases, select the database that you want to delete, and then click “Delete”.
    Delete the database

In this manner, you can manage your PostgreSQL Databases. For more information on the database, visit our knowledge base section.

Spread the love
Dominos Search