Tuesday, December 19, 2017

Installing PhpPgAdmin on Fedora

Installation


Install postgresql and apache httpd

Install PhpPgAdmin:

sudo yum install phpPgAdmin

pg_hba.conf


Modify the pg_hba.conf file and change the following line:

local   all             all                                     peer

to this

local   all             all                                     md5

This will allow a password to be entered when the PhpPgAdmin app tries to login to the postgresql server.

phpPgAdmin.conf


If you've installed phpPgAdmin on Fedora (or likely other Linuxes such as CentOS or RHEL), you'll need to modify the /etc/httpd/conf.d/phpPgAdmin.conf to open up access.  In the Apache 2.4 section, put only this line in:

Require all granted

Then restart the httpd web server.

Then try to login here: http://localhost/phpPgAdmin - you will use the same login and password that you use to login into postgresql with the psql command line utility.


No comments: