Thread: Problem doing pg_dumpall

Problem doing pg_dumpall

From
alvaro@audifarma.com.co
Date:
Hi,

I got this error when I run pg_dump:

# pg_dumpall > data_dump
pg_dump: could not find namespace with OID 102548365
pg_dumpall: pg_dump failed on dbsa, exiting

# pg_dump -d dbsa > data_dump
pg_dump: could not find namespace with OID 102548365

# pg_dumpall -v > data_dump
pg_dumpall: dumping database "dbsa"...
pg_dumpall: running pg_dump  -v -X use-set-session-authorization -Fp 'dbsa'
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
pg_dump: could not find namespace with OID 102548365
pg_dump: *** aborted because of error
pg_dumpall: pg_dump failed on dbsa, exiting

How can I solve this problem?

How can I tell what is the OID 102548365? is it related to an index or a
table or what?

I search the web looking for answers to these questions but I cludn't find
them.

Thanks a lot for you help,

Alvaro


Re: Problem doing pg_dumpall

From
Tom Lane
Date:
alvaro@audifarma.com.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