Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E1F322E33A7 for ; Thu, 6 Dec 2007 13:12:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 38021-02-6 for ; Thu, 6 Dec 2007 13:11:59 -0400 (AST) Received: from banan.pingpong.net (banan.pingpong.net [213.136.40.205]) by postgresql.org (Postfix) with ESMTP id 660E12E33A1 for ; Thu, 6 Dec 2007 13:12:00 -0400 (AST) Received: from rambutan.pingpong.net (rambutan.pingpong.net [192.168.1.187]) by banan.pingpong.net (Postfix) with ESMTP id 6D3081CC50; Thu, 6 Dec 2007 18:11:57 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by rambutan.pingpong.net (8.14.2/8.14.2) with ESMTP id lB6HBvCQ030352; Thu, 6 Dec 2007 18:11:57 +0100 (CET) (envelope-from girgen@pingpong.net) Date: Thu, 06 Dec 2007 18:11:57 +0100 From: Palle Girgensohn To: Palle Girgensohn , Scott Marlowe cc: pgsql-admin@postgresql.org, kudo@pingpong.net Subject: Re: lost data, possible playback? Message-ID: <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> In-Reply-To: <4B1BF9CA998264A329F566B6@rambutan.pingpong.net> References: <9FD29C9B828B9182011BDDF5@rambutan.pingpong.net> <4B1BF9CA998264A329F566B6@rambutan.pingpong.net> 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/29 X-Sequence-Number: 27546 --On torsdag, december 06, 2007 17.45.57 +0100 Palle Girgensohn wrote: > > > --On torsdag, december 06, 2007 10.41.40 -0600 Scott Marlowe > wrote: > >> On Dec 6, 2007 10:24 AM, Palle Girgensohn wrote: >>> Hi! >>> >>> A user accidentally deleted some results (i.e. tuples in a postgresql >>> database) created this morning. >>> >>> I have pg_xlog from about 9 o'clock until now. I have a pg_dump from ab >>> out 3 o'clock this morning. >>> >>> The results where created from about nine o'clock until noon, when the >>> user accidentally removed the results. >>> >>> Would it be possible to replay the WAL logs and get the results from >>> pg_xlog + the dump? >> >> No. >> >>> Or from a file system snapshot as of now (five pm) + pg_xlog? >> >> No. > > So, I *must* have an image of the entire database, and I *must* have all > WAL files since the image snapshot was taken? Is the real reason for the negative answer that there is a "hole" in the pg_xlogs from 3 am - 9 am? Palle