Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 709902E0035 for ; Tue, 8 Apr 2008 17:44:11 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51565-04 for ; Tue, 8 Apr 2008 17:44:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id 923AD2E003D for ; Tue, 8 Apr 2008 17:44:03 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 202DD470005 for ; Tue, 8 Apr 2008 22:44:01 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id L0XQy5wADonp for ; Tue, 8 Apr 2008 22:44:01 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 084FA470003; Tue, 8 Apr 2008 22:44:01 +0200 (CEST) Date: Tue, 8 Apr 2008 22:44:01 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: pg_dump/pg_restore Message-ID: <20080408204401.GC30442@easy2.in-chemnitz.de> References: <15aa6b3e0804081252x43fb76c3ue8eed3edbeb940c9@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <15aa6b3e0804081252x43fb76c3ue8eed3edbeb940c9@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/83 X-Sequence-Number: 28847 On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote: > I'm using postgresql 7.4, I have a problem with pg_dump/pg_restore. I > want to back and restore only one schema from my db (I did it), but > when I restore it, postgresql found errors in some views, this ones > needs of others which can't be found because the script will generate > them later. How can I make an orderer sql dump??? A quick fix would be to just restore the dump multiple times - everything which already exists will be skipped, the rest will be loaded. Repeat until everything is fine. ;-) Hope that helps, Tino. -- „Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi) www.craniosacralzentrum.de www.forteego.de