Installing Postgresql - HOWTO

[purplepaws]

Hi,

We followed ths instructions and did not have an old verison installed, however, we are getting these errors when trying to install the config file or change the password....

You are running an old unsupported postgresql version.
cPanel only supports postgres 7.3.x or better.

Anyone?

cPanel.net Support Ticket Number:

[casey]

Originally posted by purplepaws
Hi,

We followed ths instructions and did not have an old verison installed, however, we are getting these errors when trying to install the config file or change the password....

You are running an old unsupported postgresql version.
cPanel only supports postgres 7.3.x or better.

Anyone?

cPanel.net Support Ticket Number:

Did you:

Upgrade to cPanel 7.4.0 build 45 or later

I had 7.2 on my system from the rpms via whm. Running /scripts/installpostgres installed 7.3.3.

cPanel.net Support Ticket Number:

[purplepaws]

WHM 7.4.0 cPanel 7.4.0-S61

cPanel.net Support Ticket Number:

[cpanelnick]

You might have an old version still lingering

try

psql --version

to find out what version you have.

cPanel.net Support Ticket Number:

[purplepaws]

Version 7.0.3!

Never had this on this server before...confused.

cPanel.net Support Ticket Number:

[cpanelnick]

Originally posted by purplepaws
Version 7.0.3!

Never had this on this server before...confused.

cPanel.net Support Ticket Number:

Perhaps someone compiled it from source. That being the case you would need to rip it out manually.

cPanel.net Support Ticket Number:

[casey]

Will there be an equivalent of /scripts/updatemysqlquota for postgres?

cPanel.net Support Ticket Number:

[Guile]

Same here! Anyone know how to fix this?

Originally posted by Marty
It works great now except I cannot delete databases in client control panels.

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:

[purplepaws]

no idea at the moment, have not had chance to take a good look.

cPanel.net Support Ticket Number:

[dgbaker]

Originally posted by casey
Did you:


I had 7.2 on my system from the rpms via whm. Running /scripts/installpostgres installed 7.3.3.

cPanel.net Support Ticket Number:

So did we and now I have some pretty pissed off clients cause their databases are now toast.

We cannot get 7.2 working again and 7.3 won't read the old databases. Cannot run pg_dump because cannot start 7.2 to get at database.

cPanel/bdraco - Maybe next time have the HOWTO available before send out things that HAVE NO ROLL BACK. Now how do I get the databases back for my clients?

cPanel.net Support Ticket Number:

[gemby]

Is it possible to someone pack-up postgres 7.3.3 for RH 7.1?

cPanel.net Support Ticket Number:

[jough]

I installed Postgresql as instructed in the beginning of this thread, and two new options showed up in WHM: "Postgres Config" in the Server Setup and "Postgresql Server" under Restart Services.

I changed the Postgre password and ran the "Install Config" and it said it finished OK.

But when I start Cpanel in any domain nothing shows up for Postgresql.

I tried stopping and restarting the Cpanel service, but alas, no dice.

Is there another step I'm missing?

I'm running the latest STABLE WHM/CPanel release and have Postgre 7.3.4 installed.

cPanel.net Support Ticket Number:

[sexy_guy]

Originally posted by jough
I installed Postgresql as instructed in the beginning of this thread, and two new options showed up in WHM: "Postgres Config" in the Server Setup and "Postgresql Server" under Restart Services.

I changed the Postgre password and ran the "Install Config" and it said it finished OK.

But when I start Cpanel in any domain nothing shows up for Postgresql.

I tried stopping and restarting the Cpanel service, but alas, no dice.

Is there another step I'm missing?

I'm running the latest STABLE WHM/CPanel release and have Postgre 7.3.4 installed.

cPanel.net Support Ticket Number:

Its not Cpanel you want to start its PostgreSQL you want to make sure thats running. Make sure its running. /etc/rc.d/init.d/postgresql start

cPanel.net Support Ticket Number:

[jough]

Postgresql is running, but nothing regarding Postgre shows up in Cpanel.

That's the gist of my problem.

cPanel.net Support Ticket Number:

[sexy_guy]

Is PhpPyAdmin which i assume should say phpPgAdmin in feature list(Beta) checked?

cPanel.net Support Ticket Number: