- Portal Home
- Knowledgebase
- Unlimited Hosting
- cPanel X3
- PostgreSQL
Articles
You need to create a PostgreSQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the...
How can I Grant a user's permissions to a PostgreSQL database?Once you have created a user to use a database you need to grant that user permission to use the database. 1- Click on the PostgreSQL databases button on the Cpanel home page. 2- Choose the...
How can I Manage PostgreSQL databases?CPanel includes a web-based PostgreSQL management tool called phpPgAdmin. This tool allows you to manage all aspects of your database structure and data. 1- Click on the PostgreSQL databases...
How can I Remove a user's permissions?A user will no longer be able to access a particular database when you have removed their permissions to that database. 1- Click on the PostgreSQL databases button on the Cpanel home page. 2-...
How can I Remove a user?Removing a user deletes that user - it removes all database permissions that the user has and does not allow that user access to any PostgreSQL databases. 1- Click on the PostgreSQL databases...
How can Remove a database?Removing a database will delete that database from its online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a...
How to add a PostgreSQL database?1- Click on the PostgreSQL databases button on the Cpanel home page. 2- Enter the name of the database in the Db field. 3- Click on the Add Db button. The database will be added to the...
What is PostgreSQL?PostgreSQL is, like MySQL, essentially an SQL server and database - it responds to requests for information that are written in SQL. You can communicate with PostgreSQL using a wide variety of...