Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 27 Apr 2007 15:52:36 +0100
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'llneed 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)
- References:
- Finding time in WAL logs
- From: Pascal Robert
- Re: Finding time in WAL logs
- From: Simon Riggs
- Re: Finding time in WAL logs
- From: Pascal Robert
- Re: Finding time in WAL logs
- From: Simon Riggs
- Finding time in WAL logs
- Prev by Date: Re: PostgreSQL8.2.3 Performance
- Next by Date: Re: question about installing perl module
- Previous by thread: Re: Finding time in WAL logs
- Next by thread: Re: Finding time in WAL logs
- Indexes: