Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and pg_dumpall fail when trying to backup database - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump and pg_dumpall fail when trying to backup database
Date
Msg-id 12318.1078025654@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and pg_dumpall fail when trying to backup database  (jack_turer@yahoo.com (jack turer))
List pgsql-general
Tree view 
jack_turer@yahoo.com (jack turer) writes:
> 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 aggregate functions
> pg_dump: reading user-defined operators
> pg_dump: reading user-defined operator classes
> pg_dump: reading user-defined tables
> pg_dump: could not find namespace with OID 2200
> pg_dump: *** aborted because of error

So you've still got some references to the PUBLIC schema.  That's pretty
interesting --- where are they exactly?  (They might be in
pg_class.relnamespace, but I'm not sure from the above.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Irreversible performance drop after increasing shared mem
Next
From: Tom Lane
Date:
Subject: Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)