Re: Error when entering template1

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