The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql databases not being listed...

Discussion in 'General Discussion' started by rsferreira, Jul 28, 2004.

  1. rsferreira

    rsferreira Member

    Joined:
    May 20, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. rsferreira

    rsferreira Member

    Joined:
    May 20, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Problem solved. Looks like it was a postgres problem (although cPanel didn't list any error). Running fine now...
     
  3. Slav

    Slav Well-Known Member

    Joined:
    Oct 28, 2002
    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    16
    How did you fix this as i am still having this issue and i dont know how to fix it.
    Slav
     
  4. deieno

    deieno Well-Known Member

    Joined:
    Nov 16, 2003
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Floripa - Brazil
    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
     
  5. boyforeigner

    boyforeigner Well-Known Member

    Joined:
    May 18, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    How this issue was rsolved ? I am having the same problem here.
     
  6. djmerlyn

    djmerlyn Well-Known Member

    Joined:
    Aug 31, 2004
    Messages:
    203
    Likes Received:
    1
    Trophy Points:
    16
    I had to

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

    darkelder Well-Known Member

    Joined:
    Oct 8, 2004
    Messages:
    74
    Likes Received:
    0
    Trophy Points:
    6
Loading...

Share This Page