[GENERAL] pg_dump and pg_dumpall fail when trying to backup database

2004-02-20 Thread jack turer
I have a database in pgsql (7.3.2) on redhat 9. When I try a 'pg_dump mydb' to back up the database, I get: pg_dump: could not find namespace with OID 2200 Verbose version is: -bash-2.05b$ pg_dump -v mydb | more pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading user

Re: [GENERAL] pg_dump and pg_dumpall fail when trying to backup database

2004-02-28 Thread jack turer
Thank you for the idea Tom. I tried it, and it didn't fix it (there are now no rows with typnamespace=2200, the pg_dump fails with the same debug information as before. I am running 7.3.2 and never migrated from an earlier version, so maybe this bug isn't completely licked yet in this version? No

Re: [GENERAL] pg_dump and pg_dumpall fail when trying to backup database

2004-02-28 Thread jack turer
Oh, the rerun of the pg_dump was a little different after the typnamespace cleanup, but still failed.. pg_dump -v mydb | more pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading user-defined types pg_dump: reading user-defined functions pg_dump: reading user-defined ag