X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 752E611F6977 for ; Fri, 31 Mar 2006 14:01:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83782-07 for ; Fri, 31 Mar 2006 14:01:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1F57711F6920 for ; Fri, 31 Mar 2006 14:01:09 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 6B23D56423; Fri, 31 Mar 2006 12:01:09 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Fri, 31 Mar 2006 12:01:07 -0600 Date: Fri, 31 Mar 2006 12:01:07 -0600 From: "Jim C. Nasby" To: Rajesh Kumar Mallah Cc: andy.shellam@mailnetwork.co.uk, pgsql-admin@postgresql.org Subject: Re: FW: Setting up of PITR system. Message-ID: <20060331180107.GT49405@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060331:mallah.rajesh@gmail.com::kn5WGGp2hwvuf1tV:00000000000000 0000000000000000000000007Lrw X-Hashcash: 1:20:060331:andy.shellam@mailnetwork.co.uk::gHUuTyZhk63bbQd6:0000000 000000000000000000000000DZhO X-Hashcash: 1:20:060331:pgsql-admin@postgresql.org::F1thnP399Q4WbfPj:00000000000 00000000000000000000000034+A X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/401 X-Sequence-Number: 21158 On Wed, Mar 29, 2006 at 06:15:59PM +0530, Rajesh Kumar Mallah wrote: > > Also you wouldn't particular need any heavy programming ? I'm sure a simple > > shell script could be written in bash to pick out the correct files. > > OK i am posting my full script [ its not heavy programming i guess :) ] > shall be grateful if you/someone could review it . (its well commented i think) > script also carries sample data. Would you be willing to share this script at http://pgfoundry.org/projects/pgpitrha/ ? Or maybe another project would be worth starting... I know right now everyone is pretty much rolling their own when it comes to dealing with PITR, so it'd be good to at least get all the scripts in one place... -- 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