From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kasia Tuszynska <ktuszynska@esri.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: backup question
Date: Tue, 31 Mar 2009 19:34:47 -0400
Message-ID: <20709.1238542487@sss.pgh.pa.us> (raw)
In-Reply-To: <232B5217AD58584C87019E8933556D11011F008606@redmx2.esri.com>
References: <232B5217AD58584C87019E8933556D11011F008606@redmx2.esri.com>
Kasia Tuszynska <ktuszynska@esri.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ktuszynska@esri.com
Subject: Re: backup question
In-Reply-To: <20709.1238542487@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox