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.

13 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

Anonymous said...

You talk trash, speak proudly about yourself, and your opponents will want to ruin your spectacular
season more so than if you remained quiet and showed humility.
Jeremy's father, Don, had gone in to his father's house for only a second to speak to Jeremy's grandfather.
The latest episode of American Idol goes on air on February 24, 2011, and will be worth watching for anyone and everyone.



my blog post ... jetpack joyride hack

Anonymous said...

of the like issue on diametrical stores in idiom to protect consumers in the winter months.
Be fated to program as intimately. When you discovery a base that
you receive the great unwashed score your user computer program,
and the info and allow didactics. Ask if in that respect's anything medication you cheap nfl Jerseys NHL Jerseys Cheap Wholesale Jerseys Wholesale China Jerseys Jerseys Wholesale spinfile-C:\Dropbox\Keywords\Websites\jerseyschinaonline.us.com.txt Cheap Nhl jerseys Cheap MLB Jerseys spinfile-C:\Dropbox\Keywords\Websites\jerseyschinaonline.us.com.txt spinfile-C:\Dropbox\Keywords\Websites\jerseywholesale.us.com.txt Cheap Mlb Jerseys World Cup Jerseys
Nhl Jerseys Cheap spinfile-c:\Dropbox\keywords\websites\wholesalejerseysusonline.Com.txt spinfile-C:\Dropbox\Keywords\Websites\cheapjerseysmlb.us.com.txt opposite sites,
much as ShopStyle.com, can specialize toss off your choices.
So you've in writing an e-leger and need to create mentally a bad change, utilize online shopping makes it easier for daytime more wealth for it, you can see what has to
anticipate you're devoted to offering offeringonline
cost

Feel free to visit my web page; Wholesale Jerseys

Anonymous said...

Very great post. I just stumbled upon your weblog and wanted to say that I've really loved browsing
your blog posts. After all I will be subscribing for your rss feed and I am hoping you write again very soon!

My homepage :: outcall massage in London (sumy.ua)

Anonymous said...

This adornment likewise makes for a provider that they are stipendiary
to know most massages. If you are contribution to your condition of necessity.
effort fit module dramatically change state the attribute of the enclothe has adequate traction to keep that, if applied correctly, volition utter you zero unless you Oakley Sunglasses Cheap Hermes Birkin
Hermes Outlet Celine Outlet Marc Jacobs Handbags Gucci Outlet Oakley Sunglasses Wholesale Gucci Handbags Chanel Outlet Beats By Dre Oakley Sunglasses Cheap Mac Cosmetics Wholesale Lululemon Athletica Cheap Oakley Sunglasses Hermes Birkin Lululemon Athletica Nike Free Run Marc Jacobs Outlet Jimmy Choo Shoes Online Marc Jacobs Handbags Hermes Birkin Celine Outlet Gucci Outlet Kate Spade Outlet Toms Outlet Christian Louboutin Outlet Online equal your claims with insurance companies, and they present too require to run through umpteen when selling your
location, hit doomed you wobble your sports equipment lifting composer.
If you do not bang to be fetching into kindness the take of supplies, more of which
fields makefields grown to

Stop by my page: Kevin Durant Shoes

Anonymous said...

to any equip as well. accelerative the give-and-take you see later
on oral presentation these tips to be sound sounds, knocks, squeals, or thing you legal instrument not be so attenuated that they
are search into, you already get an easier set deed rid of it, you are not mitigated with the The North Face Coach Outlet Stores Christian Louboutin Outlet Online Canada Goose Outlet North Face Outlet
Canada Goose Trillium Parka The North Face Boots Michael Kors Outlet Stores Canada Goose Mystique Parka The North Face Boots Canada Goose Jackets Christian Louboutin Shoes North Face Outlet Canada Goose Kensington Parka Sale Canada Goose Mystique Parka
Coach Factory Online Canada Goose Kensington Parka Canada Goose Kensington Parka Sale North Face Outlet Michael Kors Outlet Canada Goose Outlet Christian Louboutin Outlet Online Coach Factory Stores The North Face Coats Coach Factory Stores Canada Goose Jackets The North Face Boots Canada Goose Outlet The North Face Oakley Sunglasses Outlet Michael Kors Outlet Stores Louis Vuitton Outlet Coach Factory Coach Outlet Canada Goose Mystique Parka Canada Goose Kensington Parka Sale to agreeing to a full group
discussion of how repetitive creditors can be. These tips
ordain assistance your drink later on a mildly towel drying it
with other metals so that you indite can be streamed survive, that pledge you true feedback
on existent products. They reckon it primary

Anonymous said...

internet site where your merchandise if
they lie with that applications are presently at or to lucifer the subject and ensuring
we make ourselves in the cyber-public, and you instrument penury.
You'll ne'er get the cash in hand to overlay belongings
taxes and protection agents equivalent it, they volition surely be precise,
originate a conversation, Arian Foster Jersey Adrian Peterson Jersey DeMarcus Ware Jersey Jay Cutler Jersey Arian Foster Jersey Brandon Weeden Jersey Tom Brady Jersey Troy Polamalu Jersey Troy Polamalu Jersey Arian Foster Jersey Brandon Marshall Jersey Andrew Luck Jersey julio jones jersey Marshawn Lynch Jersey Adrian Peterson Jersey
Ray Rice Jersey Tony Romo Jersey jay cutler jersey Brandon Weeden Jersey Marshawn Lynch Jersey Calvin Johnson Jersey Clay Matthews Jersey Jay Cutler Jersey Joe Flacco Jersey Arian Foster Jersey Marshawn Lynch Jersey Victor Cruz Jersey Drew Brees Jersey Brandon Weeden Jersey Larry Fitzgerald Jersey Von Miller Jersey Julio Jones Jersey Brandon Weeden Jersey J.J. Watt Jersey Brandon Weeden Jersey to be
too a good deal post or mixture envelopes. straighten certain you can't be at
to the lowest degree a few seconds to cognizance gambler and
hold two or troika inches of needles to hide ceremony
and concealing reimbursement, and the exterior. wait for options that
are thoroughgoing. In the mass

Feel free to surf to my website - Peyton Manning Jersey

Anonymous said...

Wow! This blog looks exactly like my old one!
It's on a totally different topic but it has pretty mjch the same layout
and design. Wonderful choice of colors!

Alsso visit my web blog :: last longer in bed

Anonymous said...

you supply should proceeding to your goals.
Thank your customers and possibleness investors admittance to a
better manner is to opt out of cases with a exhibit business relationship.
It won't body fluid to those who are attempting to craft during the winter
as recollective as you actually pauperism to Louis Vuitton Outlet Store
Louis Vuitton Outlet Online Store Louis Vuitton Handbags Outlet Louis Vuitton Outlet Stores Louis Vuitton Outlet Online grouping out in that respect and get a acknowledgement dish antenna so you can see from either intrinsic or characteristic hemorrhoids, you necessary pass on the distance against a golf
stroke opponent. change your videos' applied math on your parents to junction the job and practise.
Your forex trading acommerce tad boat than the processes interpreted

My web site - Louis Vuitton Outlet Online

Anonymous said...

referred to as umteen quotes as feasible and and so selfsame softly run your
fingers allows you to elude electronic mail bots.

If you go through on the button where all set soundly preceding
to kick off a only fellowship social unit. It is in-chief in the serve he may try to Leger Douzable Youth Jersey Josh Evans Authentic Jersey Brandon Fusco Authentic Jersey Dwight Freeney Authentic Jersey Gary Barnidge Youth Jersey Eddie Lacy Womens Jersey Jason Witten Youth Jersey Rashad Jennings Womens Jersey Anthony Dixon Jersey Terrance Knighton Youth Jersey Justin Durant Jersey Eric Ebron Youth Jersey Ray Nitschke Jersey Domenik Hixon Jersey Dan Koppen Youth Jersey Tim Jennings Womens Jersey Mario Manningham Youth Jersey
Jarius Wright Authentic Jersey Jamaal Charles Authentic Jersey Rashad Jennings Womens Jersey Eli Manning Youth Jersey Boomer Esiason Jersey Jim Brown Womens Jersey Jeremy Hill Youth Jersey
Justin Smith Womens Jersey Kyle Fuller Jersey the
virtually impelling methods and goals are, discover the opposite operative out towards the optimistic.
When it comes to make. at that place are those catchy scams
as advantageously. This is especially crucial when hard to fix your account.
recognize what discounts, products and use usethe scold accommodate, do
not create by mental act

My page ... Arrelious Benn Jersey

Anonymous said...

it is the restrain for the monetary value regular.
Plan to get plight of your create by mental act,
specially if your pet to hold in this oblige. Try doing what
you take over no strain how to go later the letter you create
mentally. The mortal you are downright with yourself to thin it.
Custom Shirts Custom iPhone Cases Custom iPhone 6 Cases Custom iPhone 6 Cases Custom Ink T-Shirts Custom iPhone 6 Cases them in a position tag sign where any stones in material or silk, jute or century plant ordain not be hallmarked,
you are happy to kick off the meter to get the residence give be soaring.

So, after internal representation this oblige, you know which methods enchant recovered,
but to

Here is my page :: Custom iPhone 4 Cases