phpPgAdmin is an application that enables you to set up and manage PostgreSQL databases directly through a web browser.
phpPgAdmin in cPanel
The web tool phpPgAdmin that enables you to manage PostgreSQL databases is available in your cPanel. However, it won’t be possible to perform all kinds of actions with the database because it uses the cPanel user.
You can login only by using the cPanel user. To access a certain database with its assigned user you will need to install an additional phpPgAdmin in your hosting account
Installing phpPgAdmin
We recommend using an additionally installed phpPgAdmin to set up and manage PostrgeSQL databases.
Installing the tool is easy as it is practically placing the system files into your hosting account. After you download the installation package from the official website, upload the archive file into your hosting account in a directory of your choice and extract its contents.
Open the directory with the extracted files in a web browser.
Click PostgreSQL (1) and enter a database username and a password in the login form (2).
You should create a user in advance and assign it to the database by accessing cPanel -> PostgreSQL Databases.
Configuring phpPgAdmin
After logging into the database with your username, you can create and configure schemes or tables, change permissions, etc.
Each new PostgreSQL database contains a schema named “public” (1).
We recommend that you create your own schema (2) that is different from public.
Thus your database user will be the owner (!) of the new schema and you will have full access to change any settings.
Schema Аctions:
Drop: You can remove the schema. Select the CASCADE option so that all dependent objects such as tables, functions, etc. are deleted.
Privileges: You can grant or revoke access rights.
Alter: You can modify the schema name or its comment.
If you wish to specify that a certain schema, other than public, is to be used in a CMS, go to the prefix tables settings. There first enter the schema name, then a dot and the prefix. For example: define(‘TABLE_PREFIX’, ‘myschema.tblprefix_‘);.
If a database is used by multiple applications, the schemas are very convenient and logical way to keep their data separate. You can generate a separate schema for each application. As shown in the example above, the wolf schema will be used by Wolf CMS.
