The Postgres Account Maintenance Menu allows you to create PostgreSQL databases and users, and to modify the databases and access to them. SQL stands for Structured Query Language. SQL is an international standard in querying and retrieving information from databases. PostgreSQL is essentially an SQL server - it responds to requests for information that are written in SQL.
To access the Postgres Account Maintenance Menu, click on the icon above the words PostgreSQL Databases on the main screen of your cPanel interface.
Enter the name of the new database in the blank field next to Db:
Click on Add Db to create the database. You need to create at least one database user and grant that user permission to use the new database.
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 specific database first.
Select the user (the user will appear as mainuser_user) you wish to grant permissions for from the drop box next to User:
Select the database (the database will appear as mainuser_database) you wish to give that user access to from the drop box next to Db:
Select any privileges (abilities to modify the database) you wish the user to have by checking the box next to the privilege's name.
Click on Add User to Db to give the user permission to access the database.
