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

Re: Finding time in WAL logs

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Pascal Robert" <probert(at)os(dot)ca>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Finding time in WAL logs
Date: 2007-04-25 19:53:04
Message-ID: 1177530784.20637.230.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, 2007-04-25 at 14:49 -0400, Pascal Robert wrote:
> >> BTW, the statements look like this :
> >>
> >> 	0/15FFE470: prv 0/15FFE440; xid 2332; HEAP  info 10 len 18  
> >> tot_len 46
> >> 	DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
> >> 1413 off 5
> >>
> >> (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.
> 
> Ok, so I guess that auto commited statements will never have date/time ?

There'll be a COMMIT record for every transaction, however it was
initiated, unless the server crashed/shutdown before it could be issued.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

pgsql-admin by date

Next:From: Dan DanDate: 2007-04-25 20:03:35
Subject: continuous archive with v823
Previous:From: Pascal RobertDate: 2007-04-25 19:20:28
Subject: Re: Finding time in WAL logs

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