Connecting Postgresql 9.0 and phpPgAdmin-5.0.3 to cPanel in Centos 6

After installing PostgreSql 9.0, compile php and apache using WHM > Easyapache --with-pgsql option

For instructions on installing PostgreSQL 9.0 in Centos 6, click here

Download phpPgAdmin 5.0.3.tar.gz to this location:
/usr/local/cpanel/base/3rdparty

Extract the dowloaded file and rename the extracted phpPgAdmin-5.0.3 directed to phppgadmin.

Edit config.inc.php located in /usr/local/cpanel/base/3rdparty/phpPgAdmin/conf/config.inc.php

Find the line $conf['extra_login_security'] = true;

Set it to false.

Restart postgresql.
In WHM go to Restart Services > SQL Server (PgSQL)
Or in the console prompt type:
service postgresql-9.0 restart

I also restarted Apache
service httpd restart

At this point, the phpPgAdmin link shall be functional - but not the PostgreSQL link. If yo click it, cPanel will warn you that PostgreSQL is

offline.

PostgreSQL may be running but cPanel cannot find the data files.

Additional steps need to be done to connect Postgres to cPanel.

Edit pg_hba.conf located in /var/lib/pgsql/9.0/data
vi /var/lib/pgsql/9.0/data/pg_hba.conf
Find the following lines:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5

Change md5 to trust, thus:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5

This will be only temporary. In the succeeding steps "trust" shall be reverted to "m5" automatically.

Restart postgresql.

Go to SQL Services > Postgres Config

At this point, you are not ready yet to click the configuration buttons. If you do, WHM will warn that data directory could not be found.

Starting Postgresql version 9, postgresql installs files in different location and cPanel expects to find them in the old install locations.

So, we need to create symlinks from the new location to the old locations where cPanel expects to find the files.

Type the following in the console prompt (This has no equivalent in WHM):
ln -s /var/lib/pgsql/9.0/data /var/lib/pgsql
ln -s /var/lib/pgsql/9.0/backups /var/lib/pgsql

Then you can click the Install Config button and get a success confirmation message from WHM.

Re-enter the Postgres password and click Change Password.

Restart Postgresql.

If you check pg_hba.conf, you will find these llines again:
local all all md5
host all all 127.0.0.1 255.255.255.255 md5

Note that trust has been reverted to md5.

Now you can access Postgresql 9.0 databases from cPanel using the PostgreSQL Databases or the phpPgAdmin link.

3 comments:

Anonymous said...

Hi there! This post could not be written any better!
Reading through this post reminds me of my old room mate! He
always kept talking about this. I will forward
this article to him. Fairly certain he will have a
good read. Thank you for sharing!

Feel free to surf to my website; netdepot Testimonials

Anonymous said...

Gravity then causes water to be under pressure
as it flows from the elevated tanks to consumers.

mode     modi     mods     mogs     moil    
mojo     moke     mola. swanlike swannery swanning swanpans
swanskin swappers swapping swarajes.

Check out my homepage ... czeo.net ()

Anonymous said...

Admiring the persistence you put into your website and detailed information you provide.

It's great to come across a blog every once
in a while that isn't the same unwanted rehashed information. Wonderful read!
I've saved your site and I'm including your RSS feeds to my Google
account.

Also visit my site: htc one m8