Problem with postgresql after upgrade

[oocr83]

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

 

[oocr83]

now can view database but... not show tables in log show:

[email protected] [/var/lib/pgsql/data/pg_log]# cat postgresql-Wed.log
ERROR: cache lookup failed for type 0
ERROR: cache lookup failed for type 0
[email protected] [/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.

 

[cPanelTristan]

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.