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.

Problem with postgresql after upgrade

Discussion in 'General Discussion' started by oocr83, Oct 3, 2012.

  1. oocr83

    oocr83 Registered

    Joined:
    Oct 3, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello everyone

    i have a issue.. after change a disk of server for many problems of writting, the postgresql versions has changed, before i had version 8.1 now have 8.4 .. the issue is.. how can do to new installation of postgresql recognize files of old databases?

    i put files on base/ folder but no works :(
     
  2. oocr83

    oocr83 Registered

    Joined:
    Oct 3, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    now can view database :) but... not show tables :( in log show:

    root@server [/var/lib/pgsql/data/pg_log]# cat postgresql-Wed.log
    ERROR: cache lookup failed for type 0
    ERROR: cache lookup failed for type 0
    root@server [/var/lib/pgsql/data/pg_log]#

    cant find solution yet..


    and browser show:

    SQL error:

    ERROR: cache lookup failed for type 0
    In statement:

    SELECT pn.nspname AS schema, pu.usename AS owner,
    SUBSTRING(pn.nspname FROM 2) AS cluster,
    pg_catalog.obj_description(pn.oid, 'pg_namespace') AS
    nspcomment
    FROM pg_catalog.pg_proc pp, pg_catalog.pg_namespace pn,
    pg_catalog.pg_user pu
    WHERE pp.pronamespace=pn.oid
    AND pn.nspowner = pu.usesysid
    AND pp.proname='slonyversion'
    AND pn.nspname LIKE '@_%' ESCAPE '@'
    ORDER BY pn.nspname LIMIT 1


    Fatal error: Call to a member function recordCount() on a non-object in /usr/local/cpanel/base/3rdparty/phpPgAdmin/classes/plugins/Slony.php on line 57

    ty.
     
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Could you try updating the password for the user in WHM > Password Modification area to see if the postgresql password also updates for the account? The only ticket I was able to find with the same error "Call to a member function recordCount() on a non-object" shows it was due to a password issue with the account in question for postgres.
     
Loading...

Share This Page