Riyad Aufari <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
