Postgresql databases not being listed...

[rsferreira]

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]

Problem solved. Looks like it was a postgres problem (although cPanel didn't list any error). Running fine now...

 

[Slav]

How did you fix this as i am still having this issue and i dont know how to fix it.
Slav

 

[deieno]

same problem

Hi, if you got the solution,
please tell us. I have the same issue and I do not find how to solve this..

Thanks

 

[boyforeigner]

How this issue was rsolved ? I am having the same problem here.

 

[djmerlyn]

I had to

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

 

[darkelder]

Try a possible fix: http://forums.cpanel.net/showthread.php?p=189646