Postgresql databases not being listed...

rsferreira

Member
May 20, 2003
9
0
151
Hi;

We're using cPanel 9.4.1-STABLE 65 and PostgreSQL 7.3.4, on a RH9 system.

For some reason, cpanel stopped listing psql databases and users. If someone create a pgsql db, although it says 'database created', this database won't show up in the databases list on cpanel. Those that were already created aren't listed either.

Looks like the <cpanel Postgres="listdbs()"> cpanel function called in [theme]/psql/index.html is not working, as aren't working the other cpanel postgres functions.

I've checked, and the Postgres class is there:
/usr/local/cpanel/Cpanel/Postgres.pm

However, for some reason, it doesn't retrieve data anymore.

Does anyone have an idea on what could be causing this?

Regards,
Rodrigo
 

rsferreira

Member
May 20, 2003
9
0
151
Problem solved. Looks like it was a postgres problem (although cPanel didn't list any error). Running fine now...
 

Slav

Well-Known Member
Oct 28, 2002
144
0
166
How did you fix this as i am still having this issue and i dont know how to fix it.
Slav
 

djmerlyn

Well-Known Member
Aug 31, 2004
201
1
168
I had to

mv -f /var/lib/pgsql /var/lib/pgsql.old
yes | /scripts/installpostgres