Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7A8C79FB367 for ; Thu, 26 Oct 2006 00:09:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 61745-04 for ; Thu, 26 Oct 2006 03:08:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 55A059FB2ED for ; Thu, 26 Oct 2006 00:08:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from tripitaka.dmz.gpats.com.au (global72.lnk.telstra.net [165.228.229.246]) by svr4.postgresql.org (Postfix) with ESMTP id 364F45AF893 for ; Thu, 26 Oct 2006 03:08:47 +0000 (GMT) Received: from firefly.intranet.gpats.com.au ([192.168.2.33] helo=Firefly) by tripitaka.dmz.gpats.com.au with smtp (Exim 4.50) id 1Gcvbm-0000is-BG for pgsql-admin@postgresql.org; Thu, 26 Oct 2006 13:08:42 +1000 Message-ID: <018701c6f8ac$0ad93bf0$2102a8c0@Firefly> From: "Duncan McDonald" To: Subject: Backing Up Partial Databases Date: Thu, 26 Oct 2006 13:08:42 +1000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/171 X-Sequence-Number: 23474 Hi All, I was wondering whether there was a way to back up partial sets of data as INSERT statements? Pg_dump seems only to handle whole databases or tables. I have two identical databases (primary and backup) and I need to transfer a small portion of missing data from one to the other. Is there an easier way to do this rather than SELECT-ing the interval then parsing the ouput to look like INSERT statements? Regards, -Duncan