How To Manage PostgreSQL Databases

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”.
   
2. Search for the “Databases” section, and click on the “PostgreSQL Databases”.
   
3. Under “Create New Database”, type the name of the database, and click on “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.
   
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”.
   

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”.
   

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