Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A0BA22E337B for ; Thu, 6 Dec 2007 13:35:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 11476-03 for ; Thu, 6 Dec 2007 13:35:01 -0400 (AST) Received: from banan.pingpong.net (banan.pingpong.net [213.136.40.205]) by postgresql.org (Postfix) with ESMTP id 2F7CC2E3060 for ; Thu, 6 Dec 2007 13:35:02 -0400 (AST) Received: from rambutan.pingpong.net (rambutan.pingpong.net [192.168.1.187]) by banan.pingpong.net (Postfix) with ESMTP id 620721CC59; Thu, 6 Dec 2007 18:35:01 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by rambutan.pingpong.net (8.14.2/8.14.2) with ESMTP id lB6HYwNh030413; Thu, 6 Dec 2007 18:35:01 +0100 (CET) (envelope-from girgen@pingpong.net) Date: Thu, 06 Dec 2007 18:34:58 +0100 From: Palle Girgensohn To: Tom Lane cc: Scott Marlowe , pgsql-admin@postgresql.org, kudo@pingpong.net Subject: Re: lost data, possible playback? Message-ID: <944C667FD85B40CE6350DB41@rambutan.pingpong.net> In-Reply-To: <16747.1196961765@sss.pgh.pa.us> References: <9FD29C9B828B9182011BDDF5@rambutan.pingpong.net> <4B1BF9CA998264A329F566B6@rambutan.pingpong.net> <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> <16747.1196961765@sss.pgh.pa.us> X-Mailer: Mulberry/4.0.8 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/31 X-Sequence-Number: 27548 --On torsdag, december 06, 2007 12.22.45 -0500 Tom Lane wrote: > Palle Girgensohn writes: >> Is the real reason for the negative answer that there is a "hole" in the >> pg_xlogs from 3 am - 9 am? > > That's half of it. The other half is that what you have from 3am is a > pg_dump, not a filesystem-level snapshot of the database, and you'd need > the latter to be able to replay the WAL log against. OK, my assumptions where correct. Thanks. /Palle