Home
/
Site Tools vs. cPanel
/
Databases
/
How to manage my PostgreSQL database from the PostgreSQL Manager?

How to manage my PostgreSQL database from the PostgreSQL Manager?

How to create a PostgreSQL database?

To create a PostgreSQL database, go to your Site Tools > Site > PostgreSQL and click on Create Database.

Create a PostgreSQL database

How to create a PostgreSQL user?

To create a Postgre user, go to the Users tab in the PostgreSQL Manager, and click on Create User.

Create a Postgre SQL user

Then you can add the newly-created username to an existing database. For this purpose, go to the kebab menu for the corresponding user and choose Add New Database. Select the database from the drop-down menu and click on Confirm.

How to manage PostgreSQL users?

To rename, delete or change the password of database users in Site Tools, you need to go to the PostgreSQL Manager. Under the Users tab, you will find a Manage users table with all PostgreSQL users listed. From the Actions menu next to each user you can select the option you need.

Manage PostgreSQL users

How to add users to my PostegreSQL database?

To add a new user to your PostgreSQL database, go to the PostgreSQL Manager Databases tab and click the Add New User icon.

Add a Postgre user to a database

Alternatively, you can as well add users to a database from the Users tab in the PostgreSQL Manager. Right next to each user in the Manage Users table, you will find an Add New Database button.

Add a new database to a Postgre user

How to manage user privileges to a PostgreSQL database?

To manage user privileges to a PostgreSQL database, go to the Users tab in the PostgreSQL Manager. There next to the user under Manage users, click on the database icon and select Manage Access.

Manage user privileges Postgre SQL

In the pop-up that will come up, you can choose what privileges to assign to the particular user for database access.

How to set up a remote connection to my PostgreSQL database?

To set up a remote connection to your database, go to the Remote tab in the PostgreSQL Manager. After that fill in the IP address from which you want to connect. This will allow you to connect to the database server via а remote PostgreSQL client.

If you want to add an IP range, you can do that by using a 0 (zero), which acts as a wildcard character. For example, to allow access from all IPs starting with 1.2.3, enter 1.2.3.0.

You can also add a Label for the IP.

remote access Postgre SQL

If you are experiencing any issues with your PostgreSQL database, do not hesitate to contact us through one of our support channels 24/7.

Share This Article