Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 450D49FC030 for ; Wed, 9 May 2007 12:45:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 27727-06 for ; Wed, 9 May 2007 12:45:22 -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.232]) by postgresql.org (Postfix) with ESMTP id 1E9A59FC022 for ; Wed, 9 May 2007 12:45:23 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so240438wra for ; Wed, 09 May 2007 08:45:22 -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=hXdHmNlXd/xwZBze2KfUki4nSoLQ0TlVDCDnatBQ+irbVv5V40OsFkr3slmIuWrcTDg+/zRJq1HGiBgvFV/NB6cBLn1GbQG1FYrdr09cbEDeRUhflfheX5I5x3+MTs2YcEhGK1PbXGrdQLJ/OVjDUKY61o2xloV0laUd/48z8Ws= 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=BwZo4D3/9Wp2J8ItyESd45D3ukkqbFy1ex5f6TSzHHsL29acbZtJrcRUz1v98xF0IH2RUNcgqYQx0XroVrbc+0i0DASOhIsuOBliIb+N0iJ5B3LbkI60kxiacuK35DaGfsBHJXNVa8SJHqJesbrlnraziLjeeigQnmL0wv8kW9s= Received: by 10.115.32.1 with SMTP id k1mr224305waj.1178725521710; Wed, 09 May 2007 08:45:21 -0700 (PDT) Received: by 10.114.126.2 with HTTP; Wed, 9 May 2007 08:45:21 -0700 (PDT) Message-ID: <565237760705090845j765e91bet522bb07cfb8995aa@mail.gmail.com> Date: Wed, 9 May 2007 08:45:21 -0700 From: "Dhaval Shah" To: "Jeff Davis" Subject: Re: PITR and tar Cc: pgsql-general@postgresql.org In-Reply-To: <1178645330.24902.22.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> <1178645330.24902.22.camel@dogma.v10.wvs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/457 X-Sequence-Number: 113652 Looks like a problem specific to FreeBSD. I use Centos/postgres 8.2.3 and I do not see that problem at all. Dhaval On 5/8/07, Jeff Davis wrote: > On Tue, 2007-05-08 at 13:24 -0400, Merlin Moncure wrote: > > 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? > > > > Yes. I have a battery-backed cache as well, and there were no power > failures involved. > > Regards, > Jeff Davis > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Dhaval Shah