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 0036F565AD for ; Fri, 13 May 2005 06:11:33 -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 93881-10 for ; Fri, 13 May 2005 09:11:32 +0000 (GMT) Received: from mix.inar.ru (mix.inar.ru [212.14.161.14]) by svr1.postgresql.org (Postfix) with ESMTP id 84F17565AB for ; Fri, 13 May 2005 06:11:28 -0300 (ADT) Received: (from mike@localhost) by mix.inar.ru (8.8.5/8.8.5) id NAA25571 for pgsql-admin@postgresql.org; Fri, 13 May 2005 13:11:18 +0400 (MSK/MSD) Message-Id: <200505130911.NAA25571@mix.inar.ru> Subject: Incremental backup To: pgsql-admin@postgresql.org Date: Fri, 13 May 2005 13:11:18 +0400 (MSK/MSD) From: Michael Kichanov X-Mailer: ELM [version 2.4ME+ PL117 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.087 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: * X-Archive-Number: 200505/179 X-Sequence-Number: 17608 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 postgres 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