Thread: Error when entering template1

Error when entering template1

From
Riyad Aufari
Date:
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


Re: Error when entering template1

From
Tom Lane
Date:
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