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 CAB72D1B26D for ; Fri, 2 Jul 2004 01:12:01 -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 71637-04 for ; Fri, 2 Jul 2004 04:11:59 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id 807C0D1B191 for ; Fri, 2 Jul 2004 01:11:57 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (rwcrmhc12) with ESMTP id <2004070204115701400o84vte>; Fri, 2 Jul 2004 04:11:57 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i624AX1H023655; Thu, 1 Jul 2004 23:10:34 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i624AXBT023652; Thu, 1 Jul 2004 23:10:33 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: Dumping partial database content From: mike g Reply-To: mike@thegodshalls.com To: h_harush@hotmail.com Cc: pgsql-admin@postgresql.org In-Reply-To: <3b30f7df.0406300407.2b192621@posting.google.com> References: <3b30f7df.0406300407.2b192621@posting.google.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1088741432.23457.30.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Thu, 01 Jul 2004 23:10:33 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/33 X-Sequence-Number: 14101 I don't believe there is an option in pg_dump that current handles that. It is the whole table / object or nothing at all. Depending on the volume of transactions and frequency that you need to dump the data will determine which solution works best for you. Heavy volume and/or dumps multiple times per hour: Replication would probably be the best solution-perhaps Slony. Occasionaly or small volume: A Perl script / cron job that executes a SELECT * FROM x WHERE date > $passed parameter when calling the script. One time: Use pgadminIII or psql to execute a SELECT query and direct the results into a file. Mike On Wed, 2004-06-30 at 07:07, h_harush@hotmail.com wrote: > Hi, > > I need to dump only partial content of my database, for example i want > to dump only records that has been insterted to the database from a > specific date. > I tried to use pg_dump/pg_export but did not find anything usefull. > > I'm using postgres version 7.3 on Linux RH 7.3 > > any idea/direction ? > > Regards, > Hanan > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster