Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EB63A2E2FF4 for ; Thu, 6 Dec 2007 13:23:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18971-01 for ; Thu, 6 Dec 2007 13:23:21 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 01C912E02C8 for ; Thu, 6 Dec 2007 13:23:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lB6HMjKw016748; Thu, 6 Dec 2007 12:22:45 -0500 (EST) To: Palle Girgensohn cc: Scott Marlowe , pgsql-admin@postgresql.org, kudo@pingpong.net Subject: Re: lost data, possible playback? In-reply-to: <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> References: <9FD29C9B828B9182011BDDF5@rambutan.pingpong.net> <4B1BF9CA998264A329F566B6@rambutan.pingpong.net> <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> Comments: In-reply-to Palle Girgensohn message dated "Thu, 06 Dec 2007 18:11:57 +0100" Date: Thu, 06 Dec 2007 12:22:45 -0500 Message-ID: <16747.1196961765@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/30 X-Sequence-Number: 27547 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. regards, tom lane