Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7E76B9FA4AA for ; Tue, 8 May 2007 14:24:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 98088-01 for ; Tue, 8 May 2007 14:24:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.236]) by postgresql.org (Postfix) with ESMTP id 4DAFC9FA49D for ; Tue, 8 May 2007 14:24:29 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so1934977wra for ; Tue, 08 May 2007 10:24:29 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AkAdEK7K/eaaQrU9CT0pCED2mxnQHvMq+EAGR1B36m+xyNjM/qP/EDm3taztAx60T14KNzaVtxEUTB4LcLjQzXZJsjbPaHFHv8K8zQU/Sxd/lIYSfBQnTIBWBFHD1cojb1GLyliRFIndX5StD2gZm6fk/tW9ExZ7953+VcbFDvg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EDjpPr/sTBG6JCdT3/QGyTZO5EYZocGvJG3F15SnXZax0upzKp7lLv1KGitubJyFttabS5ydLajiJrOOHiRwP06oBcE3udACliE5cOvcjx1p4q/2nOaoLpVLcqIVfSp5s7XbZb5GdgSIfFuEdNhAsC6AjjbjInyh7o3fXjgn79A= Received: by 10.78.175.8 with SMTP id x8mr2418244hue.1178645068095; Tue, 08 May 2007 10:24:28 -0700 (PDT) Received: by 10.78.56.20 with HTTP; Tue, 8 May 2007 10:24:28 -0700 (PDT) Message-ID: Date: Tue, 8 May 2007 13:24:28 -0400 From: "Merlin Moncure" To: "Jeff Davis" Subject: Re: PITR and tar Cc: "Albe Laurenz" , pgsql-general@postgresql.org In-Reply-To: <1178644610.24902.20.camel@dogma.v10.wvs> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1178564286.23358.7.camel@dogma.v10.wvs> <1178644610.24902.20.camel@dogma.v10.wvs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/374 X-Sequence-Number: 113569 On 5/8/07, Jeff Davis wrote: > On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote: > > > The docs recommend using tar to perform a base backup for PITR. > > > > > > Usually, tar reports notices like: > > > "tar: Truncated write; file may have grown while being archived." > > > > Did you call pg_start_backup(text) before you started to archive? > > > > I was referring to the result of the tar itself being a corrupted gzip > file (that couldn't be uncompressed with gunzip). > > I did indeed call pg_start/stop_backup(). is fsync on? merlin