| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | jack_turer(at)yahoo(dot)com (jack turer) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump and pg_dumpall fail when trying to backup database |
| Date: | 2004-02-29 03:34:14 |
| Message-ID: | 12318.1078025654@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
jack_turer(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-29 03:35:47 | Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4) |
| Previous Message | Tom Lane | 2004-02-29 03:30:12 | Re: Irreversible performance drop after increasing shared mem |