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 CD93BD9A15 for ; Fri, 14 Oct 2005 15:29:19 -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 67384-01 for ; Fri, 14 Oct 2005 18:29:15 +0000 (GMT) Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by svr1.postgresql.org (Postfix) with ESMTP id F3E69D99D8 for ; Fri, 14 Oct 2005 15:29:15 -0300 (ADT) Received: from [84.92.184.68] (helo=[192.168.0.2]) by pih-relay06.plus.net with esmtp (Exim) id 1EQUIs-0007b5-59 for pgsql-admin@postgresql.org; Fri, 14 Oct 2005 19:29:14 +0100 Message-ID: <434FF90B.4060902@lancaster.ac.uk> Date: Fri, 14 Oct 2005 19:29:31 +0100 From: Chris Jewell User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc3 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Monitoring database for changes - backup purposes References: <434FB046.5070207@lancaster.ac.uk> <200510141059.39852.darcy@wavefire.com> In-Reply-To: <200510141059.39852.darcy@wavefire.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/167 X-Sequence-Number: 19239 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. Thanks anyway, Chris -- Chris Jewell, BSc(Hons), BVSc, MRCVS Dept of Maths and Statistics Fylde College Lancaster University Lancaster Lancs LA1 4YF Darcy Buskermolen wrote: >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 >> >> > > >