X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ABE7AD76E9 for ; Fri, 14 Oct 2005 16:25:01 -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 76704-05 for ; Fri, 14 Oct 2005 19:24:52 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 465D1D96D8 for ; Fri, 14 Oct 2005 16:24:53 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 81C671529C; Fri, 14 Oct 2005 14:24:54 -0500 (CDT) Date: Fri, 14 Oct 2005 14:24:54 -0500 From: "Jim C. Nasby" To: Chris Jewell Cc: pgsql-admin@postgresql.org Subject: Re: Monitoring database for changes - backup purposes Message-ID: <20051014192454.GS23883@pervasive.com> References: <434FB046.5070207@lancaster.ac.uk> <200510141059.39852.darcy@wavefire.com> <434FF90B.4060902@lancaster.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <434FF90B.4060902@lancaster.ac.uk> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 required=5 tests=[AWL=0.008] X-Spam-Level: X-Archive-Number: 200510/168 X-Sequence-Number: 19240 On Fri, Oct 14, 2005 at 07:29:31PM +0100, Chris Jewell wrote: > Hi, > > Yes, diff would work and is my current plan, but it requires me to > perform the backup first. What I needed really was a system by which a > backup would only be run if there was something that needed backing up. I believe he meant diffing the files that store the tables. Another possibility that I think would work would be checking the last-modified timestamp of all the files in a schema. Though the easiest way to do that is probably to build a list of any files that have changed since the last backup and then figure out what schemas they're in. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461