X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C68BD1B384 for ; Wed, 9 Jun 2004 13:53:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15323-05 for ; Wed, 9 Jun 2004 16:53:04 +0000 (GMT) Received: from mpls-qmqp-02.inet.qwest.net (mpls-qmqp-02.inet.qwest.net [63.231.195.113]) by svr1.postgresql.org (Postfix) with SMTP id 1F7A6D1B381 for ; Wed, 9 Jun 2004 13:53:00 -0300 (ADT) Received: (qmail 23332 invoked by uid 0); 9 Jun 2004 15:45:52 -0000 Received: from mpls-pop-10.inet.qwest.net (63.231.195.10) by mpls-qmqp-02.inet.qwest.net with QMQP; 9 Jun 2004 15:45:52 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-10.inet.qwest.net with SMTP; 9 Jun 2004 16:52:59 -0000 Date: Wed, 09 Jun 2004 10:53:39 -0600 Message-Id: <1086800019.23855.25.camel@localhost.localdomain> From: "Scott Marlowe" To: "David F. Skoll" Cc: pgsql-admin@postgresql.org Subject: Re: Dump only part of a DB In-Reply-To: References: <1086798776.23855.11.camel@localhost.localdomain> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/122 X-Sequence-Number: 13782 On Wed, 2004-06-09 at 10:43, David F. Skoll wrote: > On Wed, 9 Jun 2004, Scott Marlowe wrote: > > > If you put the application's data into a specific schema, then you can > > dump just that schema with the -n switch... > > Thanks. That's a solution for 7.4, but some of our installed base > (especially the older ones with large DB's that cause the problem) are > still on 7.2 or 7.3. 7.3 supported schemas, but I'm not sure its pg_dump supported dumping individual ones.