Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0118A634029 for ; Tue, 31 Mar 2009 20:34:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47245-04 for ; Tue, 31 Mar 2009 20:34:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 878D4633EF2 for ; Tue, 31 Mar 2009 20:34:50 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n2VNYler020710; Tue, 31 Mar 2009 19:34:47 -0400 (EDT) To: Kasia Tuszynska cc: "pgsql-admin@postgresql.org" Subject: Re: backup question In-reply-to: <232B5217AD58584C87019E8933556D11011F008606@redmx2.esri.com> References: <232B5217AD58584C87019E8933556D11011F008606@redmx2.esri.com> Comments: In-reply-to Kasia Tuszynska message dated "Tue, 31 Mar 2009 16:27:10 -0700" Date: Tue, 31 Mar 2009 19:34:47 -0400 Message-ID: <20709.1238542487@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/272 X-Sequence-Number: 31772 Kasia Tuszynska 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