Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction ID not logged if no explicit transaction used - Mailing list pgsql-general

From Tom Lane
Subject Re: Transaction ID not logged if no explicit transaction used
Date
Msg-id 16243.1455236942@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transaction ID not logged if no explicit transaction used  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Transaction ID not logged if no explicit transaction used  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view 
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Mart�n Marqu�s wrote:
>> This really gives little use for recovery_target_xid. :(

> Hmm, you can still use pg_xlogdump to figure it out from the actual WAL,
> which has the correct XIDs.  It's obviously a worse solution though from
> the user's POV, because it's hard to figure out what WAL record
> corresponds to the change you care about ...

To what extent does the commit_ts infrastructure fix this?

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Transaction ID not logged if no explicit transaction used
Next
From: Edson Richter
Date:
Subject: XMLEXISTS on legacy XML with malformed xmlns