Postgres Pro
Downloads
Home   >   mailing lists

Re: backup question - Mailing list pgsql-admin

From Tom Lane
Subject Re: backup question
Date
Msg-id 20709.1238542487@sss.pgh.pa.us
Whole thread Raw
In response to backup question  (Kasia Tuszynska <ktuszynska@esri.com>)
List pgsql-admin
Tree view 
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
inthe 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

pgsql-admin by date:

Previous
From: Kasia Tuszynska
Date:
Subject: privilege inheritance to a login role through a group role
Next
From: Tom Lane
Date:
Subject: Re: privilege inheritance to a login role through a group role