BuycPanel Blog

BuycPanel Blog

Latest news and updates

PostgreSQL Databases in cPanel

Posted by Allura on 21 02 2018.

Introduction
PostgreSQL is an open source relational database management system. This database management system is developed by worldwide team of volunteers. Any corporation or private entity does not control PostgreSQL. The source code of PostgreSQL is available free of charge.

How to create a database
To create your first database you can use PostgreSQL Database Wizard and after that you can create your own database through few steps, they are as follows:

 	Enter your database name in the database name textbox.
 	Then click create database.
 	Then go back and you will find your database.


Current databases
Current Database shows the information or status of the existing database such as name of the database, size of the database, name of the users who can accesses the database and icons offering to delete the database or edit the name of the database.

How to remove a user from your database
If you want to remove a user from your…

Introduction

PostgreSQL is an open source relational database management system. This database management system is developed by worldwide team of volunteers. Any corporation or private entity does not control PostgreSQL. The source code of PostgreSQL is available free of charge.

How to create a database

To create your first database you can use PostgreSQL Database Wizard and after that you can create your own database through few steps, they are as follows:

  • Enter your database name in the database name textbox.
  • Then click create database.
  • Then go back and you will find your database.

Current databases

Current Database shows the information or status of the existing database such as name of the database, size of the database, name of the users who can accesses the database and icons offering to delete the database or edit the name of the database.

How to remove a user from your database

If you want to remove a user from your database, you’ll have to go through few simple steps, they are:

  • In the current database find your database and then find and select the name of the user you want to remove.
  • To remove the user’s accesses in the database just click delete.
  • And then in the confirmation dialogue box click yes.

Delete a database

Database can be deleted by few simple steps, they are:

  • From the current database list select the database you want to delete.
  • Then in the action column of the selected database select delete.
  • Then confirm delete to remove your database permanently.

Add a user to the database

To add a user to your database go through these processes:

  • From the list of the users and the database just select the user and the database in which you want to add that user.
  • Then click submit.

Change a PostgreSQL password

You can change the password of the PostgreSQL password in two steps:

  • In the current user table, click the change password in the action column next to the user that you want to change.
  • Enter and confirm the new password in their dedicated text boxes.

Change a PostgreSQL user’s name

To change a PostgreSQL use’s name, click rename in the action center of the desired user you want to rename. Then enter the new user name in the new user name text box and click proceed.

 

Delete a PostgreSQL user

To delete a PostgreSQL user click delete in the action center next to the user you want to delete. Then just click remove user to delete that account.

 

In a nutshell

Through this interface called PostgreSQL you can easily manage you own databases and user to accesses the databases.