Re: Problem doing pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: alvaro(at)audifarma(dot)com(dot)co
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem doing pg_dumpall
Date: 2003-11-23 18:48:41
Message-ID: 28537.1069613321@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

alvaro(at)audifarma(dot)com(dot)co writes:
> # pg_dumpall > data_dump
> pg_dump: could not find namespace with OID 102548365
> pg_dumpall: pg_dump failed on dbsa, exiting

Hm. It would seem that you have an invalid namespace link in one of the
other system catalogs. You could try doing
select * from pg_class where relnamespace = 102548365;
select * from pg_type where typnamespace = 102548365;
select * from pg_proc where pronamespace = 102548365;
etc until you find the problem. (Your trace suggests that pg_type is
where the problem is, but that's not certain.)

Where we go after that depends on what you find. I'd be wondering about
whether there is corruption elsewhere in the same catalog ...

Also, what PG version is this exactly?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-11-23 22:24:33 Re: pg 7.4 on debian
Previous Message Joachim Smit 2003-11-23 18:28:25 Login only once