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 B331711F6AB3 for ; Sat, 1 Apr 2006 00:28:07 -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 67341-05 for ; Sat, 1 Apr 2006 00:28:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 29C0411F6669 for ; Sat, 1 Apr 2006 00:28:04 -0400 (AST) Received: by nproxy.gmail.com with SMTP id l24so657060nfc for ; Fri, 31 Mar 2006 20:28:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XFQN8dFwyzbO7erNr9664Ruh4Ec8Qn4lmUD/8XpVq3RHW1i1rq4lBCBokPjM7nYXANeOc8qgj0WDd4xfhokbPg3nv8zH+KNbYkttrw++1Gw+rwCpKgal+4CFckzcewjQDdnJ0L4B++CYDUwNTYp6v2PavO6lZBnbj2KXV5GFleY= Received: by 10.48.254.11 with SMTP id b11mr789315nfi; Fri, 31 Mar 2006 20:28:04 -0800 (PST) Received: by 10.49.26.20 with HTTP; Fri, 31 Mar 2006 20:28:04 -0800 (PST) Message-ID: Date: Sat, 1 Apr 2006 09:58:04 +0530 From: "Rajesh Kumar Mallah" To: "Sriram Dandapani" Subject: Re: FW: Setting up of PITR system. Cc: "Jim C. Nasby" , "Tom Lane" , andy.shellam@mailnetwork.co.uk, pgsql-admin@postgresql.org In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.603 required=5 tests=[AWL=0.603] X-Spam-Score: 0.603 X-Spam-Level: X-Archive-Number: 200604/2 X-Sequence-Number: 21171 On 3/31/06, Sriram Dandapani wrote: > We have high volume inserts happening with wal files being generated > very rapidly. Will the fact that the files change as the tar happens > have any effect at all on the recovery..assuming all the appropriate wal > archive logs are available. Its absolutely safe. The documentation specifically and sufficiently dispels this doubt[ Refer Online Backup ] . All the changes to the data pages (tables/indexes) are logged to WAL before the data files are modified so the WAL replay duri= ng recovery changes the files again in the same manner. As long as wal is arch= ived properly/securly there should not be any doubt. Regds Rajesh Kumar Mallah. > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jim C. Nasby > Sent: Friday, March 31, 2006 10:11 AM > To: Tom Lane > Cc: andy.shellam@mailnetwork.co.uk; 'Rajesh Kumar Mallah'; > pgsql-admin@postgresql.org > Subject: Re: FW: [ADMIN] Setting up of PITR system. > > On Wed, Mar 29, 2006 at 09:46:30AM -0500, Tom Lane wrote: > > It definitely is a pain in the neck that GNU tar complains about files > > changing underneath it --- I've looked for a way to disable that, or > at > > least reduce it to a warning instead of an error condition, but gtar > > doesn't seem to have such a switch. You should try alternative backup > > tools such as cpio or rsync. > > Or you might submit a patch to GNU tar. There's also a BSD version of > tar, it's on at least FreeBSD (not sure if there's a stand-alone version > avaiable). It might not suffer from the same problem, though I haven't > tried it. I do have a machine I could try it with if that would help. > -- > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >