How To Install phpPgAdmin 5.6 on CentOS 7 / RHEL 7

phpPgAdmin is a web-based administration tool for managing PostgreSQL database, and it’s look and feel is very similar to that of phpMyAdmin. If you have work experience on phpMyAdmin, you won’t take much time finding the way to work with phpPgAdmin.

Set the name for your PostgreSQL instance. This setting will list your instance name in the phpPgAdmin web interface.

$conf['servers'][0]['desc'] = 'PostgreSQL 11';

Add localhost or IP Address of your PostgreSQL instance in the following server parameter.

$conf['servers'][0]['host'] = 'localhost';

If extra login security is true, then logins via phpPgAdmin with no password or certain usernames (pgsql, postgres, root, administrator) will be denied. To enable the postgres login, change it to false.

$conf['extra_login_security'] = false;

To simply hide other’s databases (owned by others) in the list, make the following condition to true.

$conf['owned_only'] = true;

Configure PostgreSQL

We will need to enable MD5 authentication on PostgreSQL so that we would be able to manage PostgreSQL instances from phpPgAdmin as well as make connections from external machines.