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

Re: Finding time in WAL logs

From: Pascal Robert <probert(at)os(dot)ca>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Finding time in WAL logs
Date: 2007-04-25 19:20:28
Message-ID: 17AB96B4-F90A-4FE4-929B-32A2807B9FC3@os.ca (view raw or flat)
Thread:
Lists: pgsql-admin
Le 07-04-25 à 14:49, Pascal Robert a écrit :

>>> 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 ?

Ok, I didn't see the commit line after the INSERT.

How can I use the -r option ?  From my understanding, I can use it to  
find specific DML, but I tried :

	-r "INSERT"
	-r INSERT
	-r insert

without any success, even if I know that I have INSERT in the log.

In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2007-04-25 19:53:04
Subject: Re: Finding time in WAL logs
Previous:From: Pascal RobertDate: 2007-04-25 18:49:14
Subject: Re: Finding time in WAL logs

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