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 70E11D9A15 for ; Fri, 14 Oct 2005 14:59:41 -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 55398-08 for ; Fri, 14 Oct 2005 17:59:35 +0000 (GMT) Received: from mail2.dbitech.ca (radius.wavefire.com [64.141.13.252]) by svr1.postgresql.org (Postfix) with SMTP id 619B2D987F for ; Fri, 14 Oct 2005 14:59:35 -0300 (ADT) Received: (qmail 20519 invoked from network); 14 Oct 2005 20:17:33 -0000 Received: from dbitech.internal.wavefire.ca (64.141.15.12) by radius.wavefire.com with SMTP; 14 Oct 2005 20:17:33 -0000 From: Darcy Buskermolen Organization: Wavefire Technologies Corp To: pgsql-admin@postgresql.org Subject: Re: Monitoring database for changes - backup purposes Date: Fri, 14 Oct 2005 10:59:39 -0700 User-Agent: KMail/1.8.2 References: <434FB046.5070207@lancaster.ac.uk> In-Reply-To: <434FB046.5070207@lancaster.ac.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200510141059.39852.darcy@wavefire.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.058 required=5 tests=[AWL=0.008, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/166 X-Sequence-Number: 19238 On Friday 14 October 2005 06:19, Chris Jewell wrote: > Hi, > > I have a query about a backup policy that I wish to implement. > Currently, we are running a PostgreSQL server with a very large database > on it. The database consists of a core of read-only tables, with tables > created by the users going by default into the user's own schemas. For > backup purposes, I have a script that uses pg_dump to create dumps of > the individual user schemas. However, this is mainly a read-only > database and information is added or updated only rarely. What I really > need is a method of monitoring the database, such that my backup script > will only back any one schema up if it has changed since it was last > backed up. Is there any way to do this? Is there a checksum function > or something that I could use? No there is not, but would a diff -q be sufficient for your needs ? > > Thanks, > > Chris -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759