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 E3D22536D9 for ; Thu, 12 May 2005 07:47:29 -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 15152-01 for ; Thu, 12 May 2005 10:47:28 +0000 (GMT) Received: from Bizone.inar.ru (is.inar.ru [212.14.160.6]) by svr1.postgresql.org (Postfix) with ESMTP id EB3EB536D1 for ; Thu, 12 May 2005 07:47:23 -0300 (ADT) Received: from mi (lo2.c1.sev.inar.ru [212.14.161.22]) by Bizone.inar.ru (8.13.1/8.13.1/INAR.20050416.1955) with SMTP id j4CAlGQr084759 for ; Thu, 12 May 2005 14:47:23 +0400 (MSD) (envelope-from mike@inar.ru) From: "Michael Kichanov" To: Subject: Incremental backup Date: Thu, 12 May 2005 14:47:14 +0400 Message-ID: <000001c556df$f6b32b00$270110ac@mi> X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.8 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200505/220 X-Sequence-Number: 17649 Hi All! I wish to realize incremental backup, i.e. to dump only those tables which have changed from last backup. 1q. How i can solve this task with internal postges tools? 2q. How I can to find out timestamp of last change of the table? Does anyone resolve this things? Ps: postgres 7.3 Thanx in advance