Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CB4BE632A78 for ; Fri, 16 Jul 2010 02:03:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 73101-07 for ; Fri, 16 Jul 2010 05:03:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mail.postgresql.org (Postfix) with ESMTP id 084CF63267E for ; Fri, 16 Jul 2010 02:03:21 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1OZd4y-0003Uq-Fj for pgsql-admin@postgresql.org; Thu, 15 Jul 2010 22:03:20 -0700 Message-ID: <29180107.post@talk.nabble.com> Date: Thu, 15 Jul 2010 22:03:20 -0700 (PDT) From: suhailck To: pgsql-admin@postgresql.org Subject: conditional backup MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: suhailck@gmail.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/102 X-Sequence-Number: 35121 Hi, I need to take backup of my postgresql DB, but not all records from a few tables. My DB contains more than 700 tables, out of which 15 tables i need to take this conditional backup Example: Table: C_order I need to take backup from table C_order where "period=2009" and "org <> A" This is done to improve performance there by deleting all non-org records for old period from org A's server. Expecting ur feedbacks Thanks in advance!!! -- View this message in context: http://old.nabble.com/conditional-backup-tp29180107p29180107.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.