Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EA9489FBF82 for ; Wed, 25 Apr 2007 16:20:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 74594-02 for ; Wed, 25 Apr 2007 16:20:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from osci.qc.ca (cgp.osci.qc.ca [216.113.25.150]) by postgresql.org (Postfix) with ESMTP id 67BBA9FBEBC for ; Wed, 25 Apr 2007 16:20:53 -0300 (ADT) Received: from [192.168.3.143] (account probert [192.168.3.143] verified) by osci.qc.ca (CommuniGate Pro SMTP 5.0.13) with ESMTPA id 9053975; Wed, 25 Apr 2007 15:20:52 -0400 In-Reply-To: References: <5B0132B1-646A-432C-8261-973E4BB42999@os.ca> <1177515789.20637.160.camel@silverbirch.site> <7697F772-07E3-469C-8E51-1450AEBC5F39@os.ca> <1177524100.20637.167.camel@silverbirch.site> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: <17AB96B4-F90A-4FE4-929B-32A2807B9FC3@os.ca> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable From: Pascal Robert Subject: Re: Finding time in WAL logs Date: Wed, 25 Apr 2007 15:20:28 -0400 To: Simon Riggs X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/238 X-Sequence-Number: 25302 Le 07-04-25 =E0 14:49, Pascal Robert a =E9crit : >>> BTW, the statements look like this : >>> >>> 0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18 =20 >>> 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 =20 >> you'll >> need to search ahead/behind. > > Ok, so I guess that auto commited statements will never have date/=20 > time ? Ok, I didn't see the commit line after the INSERT. How can I use the -r option ? =46rom my understanding, I can use it to =20= 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.=