How to Install and Configure phpPgAdmin

phpPgAdmin is an application that enables you to set up and manage PostgreSQL databases directly through a web browser.

phpPgAdmin in cPanel

phpPgAdmin, available 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.

Access to additionally installed phpPgAdminInstalling 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.

Note: It is a good idea to restrict the web access to phpPgAdmin by using a username and password. You can do this in cPanel -> Password Protected Directories.

Configuring phpPgAdmin

After logging into the database with your username, you can create and configure schemes or tables, change permissions, etc.

A list of schemes in the database

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.

Updated on 02.04.2022

Was this article helpful?

Related Articles