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 595CF53771 for ; Fri, 13 May 2005 11:13:27 -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 45765-04 for ; Fri, 13 May 2005 14:13:17 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 9F1E554D6F for ; Fri, 13 May 2005 11:13:17 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j4DEDHvH046438 for ; Fri, 13 May 2005 14:13:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j4DDo19G042596 for pgsql-admin@postgresql.org; Fri, 13 May 2005 13:50:01 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Incremental backup Date: Fri, 13 May 2005 09:30:59 -0400 Organization: cbbrowne Computing Inc Lines: 24 Message-ID: References: <200505130911.NAA25571@mix.inar.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:D90Bhs1zJtqwoKhhoCaGRb0Swk4= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200505/183 X-Sequence-Number: 17612 Centuries ago, Nostradamus foresaw when mike@inar.ru (Michael Kichanov) would write: > 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 PostgreSQL version 8 offers a "Point In Time Recovery" mechanism whereby you archive the WAL files; the WAL files represent incremental backups. Slony-I 1.1 provides a new "log shipping" feature where you can archive incremental changes, too; it tries to support versions as far back as 7.3.3, so it might be compatible with your needs... -- let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;; http://linuxdatabases.info/info/slony.html Programming is one of the most difficult branches of applied mathematics; the poorer mathematicians had better remain pure mathematicians. -- Edsger W. Dijkstra