| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kasia Tuszynska <ktuszynska(at)esri(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: backup question |
| Date: | 2009-03-31 23:34:47 |
| Message-ID: | 20709.1238542487@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Kasia Tuszynska <ktuszynska(at)esri(dot)com> writes:
> The problem arises, if data in lets say the adam schema is dependent on tables in the public schema, since the data in the public schema does not exist yet, being created later.
That's not supposed to happen. Are you possibly running an early 8.3
release? pg_dump 8.3.0-5 had a problem with user-defined operator
classes that could cause misordering of the output. If it's not that,
we'll need a lot more information.
BTW, the -i switch is dangerous. Don't use it as a routine measure.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-03-31 23:39:18 | Re: privilege inheritance to a login role through a group role |
| Previous Message | Kasia Tuszynska | 2009-03-31 23:33:53 | privilege inheritance to a login role through a group role |