[ADMIN] Problem doing pg_dumpall

2003-11-22 Thread alvaro
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 d

[ADMIN] Problem doing pg_dumpall

2004-04-19 Thread alvaro
Hi, As usual I wrote this email because I'm getting problems with posgtresql, this time is with the pg_dumpall command, hereĀ“s the story: We always make a copy of our database running [EMAIL PROTECTED]/var/lib/pgsql/bin/pg_dumpall > backup It always worked fine but lately when I run this comman

Re: [ADMIN] Problem doing pg_dumpall

2003-11-23 Thread Tom Lane
[EMAIL PROTECTED] 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_cl