Error when entering template1
I have been using postgresql (7.2.1-5) for several
years. Supprisingly, I've just got a problem when
doing pg_dumpall.
The error is :
psql: ERROR: getTypeOutputInfo: Cache lookup of type
0 failed
This error also occurs when i enter to postgres using
this command:
psql template1
User which i used was postgres.
Can anybody help me to overcome this problem. I need
to dump all database since i want to upgrade to 8.0.3.
Thanks
Raufari
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Riyad Aufari <raufari@yahoo.com> writes:
I have been using postgresql (7.2.1-5) for several
years. Supprisingly, I've just got a problem when
doing pg_dumpall.
The error is :
psql: ERROR: getTypeOutputInfo: Cache lookup of type
0 failed
This error also occurs when i enter to postgres using
this command:
psql template1
If it's just template1 that's corrupt, you could drop it and recreate it
from template0 --- see
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
This assumes you have no valuable data in template1, but I suppose you
would have noticed the problem sooner if you did.
regards, tom lane