Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 02A939FB394 for ; Wed, 25 Apr 2007 12:47:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 22459-03 for ; Wed, 25 Apr 2007 12:47:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 799D89FB28A for ; Wed, 25 Apr 2007 12:47:26 -0300 (ADT) thread-index: AceHUQ60jB6Bg+w+S8Ge0HiyH7rgLg== Received: from [172.24.32.25] ([62.232.55.118]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 25 Apr 2007 11:47:39 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826 Subject: Re: Finding time in WAL logs From: "Simon Riggs" To: "Pascal Robert" Cc: In-Reply-To: <5B0132B1-646A-432C-8261-973E4BB42999@os.ca> References: <5B0132B1-646A-432C-8261-973E4BB42999@os.ca> Content-Type: text/plain; charset="iso-8859-1" Date: Wed, 25 Apr 2007 16:43:09 +0100 Message-ID: <1177515789.20637.160.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 25 Apr 2007 15:47:40.0375 (UTC) FILETIME=[0E342E70:01C78751] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/233 X-Sequence-Number: 25297 On Wed, 2007-04-25 at 11:28 -0400, Pascal Robert wrote: > I'm writing our backup procedure for using WAL and PITR, but to be > able to do a (mostly) perfect PITR, I need to find the time when a > error (DELETE FROM, DROP TABLE, etc.) was made so that I can do a > restore just before the error. > > Does PostgreSQL has something similar to "mysqlbinlog" so that I can > look at the content of a WAL archive ? I tried enabling > "log_min_messages" at "info" level, but it doesn't log the date and > time of a executed statement, so that's not a solution. http://pgfoundry.org/projects/xlogviewer/ I'd appreciate some feedback. I'll be looking to release a new version within next few months. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com