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
