Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D0A4C2E003A for ; Thu, 6 Dec 2007 12:24:33 -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 53694-01 for ; Thu, 6 Dec 2007 12:24:31 -0400 (AST) Received: from banan.pingpong.net (banan.pingpong.net [213.136.40.205]) by postgresql.org (Postfix) with ESMTP id DEF612E0066 for ; Thu, 6 Dec 2007 12:24:30 -0400 (AST) Received: from rambutan.pingpong.net (rambutan.pingpong.net [192.168.1.187]) by banan.pingpong.net (Postfix) with ESMTP id E8A771CC61; Thu, 6 Dec 2007 17:24:29 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by rambutan.pingpong.net (8.14.2/8.14.2) with ESMTP id lB6GOTFe004491; Thu, 6 Dec 2007 17:24:29 +0100 (CET) (envelope-from girgen@pingpong.net) Date: Thu, 06 Dec 2007 17:24:29 +0100 From: Palle Girgensohn To: pgsql-admin@postgresql.org cc: kudo@pingpong.net Subject: lost data, possible playback? Message-ID: <9FD29C9B828B9182011BDDF5@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/26 X-Sequence-Number: 27543 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? Or from a file system snapshot as of now (five pm) + pg_xlog? Regards, Palle