Skip site navigation (1) Skip section navigation (2)

Re: Finding time in WAL logs

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: "Pascal Robert" <probert(at)os(dot)ca>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Finding time in WAL logs
Date: 2007-04-27 14:52:36
Message-ID: B56EBE7D-747F-4F1A-B9AA-1F76BC982906@decibel.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Apr 25, 2007, at 7:01 PM, Simon Riggs wrote:
>> (this is for a DELETE FROM table without any WHERE clause).  I see
>> the XID, but can you also display date and time in the ouput ?
>
> Original date/time is available only on COMMIT/ABORT records, so  
> you'll
> need to search ahead/behind.

Additionally, you can specify an XID when doing a point-in-time  
restore; you don't need to find an exact time to restore to.
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 2007-04-29 17:05:11
Subject: Re: question about installing perl module
Previous:From: Jonah H. HarrisDate: 2007-04-27 13:35:26
Subject: Re: PostgreSQL8.2.3 Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group