Postgres Pro
Downloads
Home   >   mailing lists

Re: Way to access LSN (for each transaction) by directly talking to postgres? - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Way to access LSN (for each transaction) by directly talking to postgres?
Date
Msg-id CAMsr+YHCRG84h8Xr=D-C+MF5N8-DC-aXqpVVcroSfP4Pmy8+Kg@mail.gmail.com
Whole thread Raw
In response to Way to access LSN (for each transaction) by directly talking to postgres?  (Joshua Bay <joshuabay93@gmail.com>)
Responses Re: Way to access LSN (for each transaction) by directly talking to postgres?  (Joshua Bay <joshuabay93@gmail.com>)
List pgsql-hackers
Tree view


On 3 August 2016 at 11:37, Joshua Bay <joshuabay93@gmail.com> wrote:
Hi,

Could you please let me know if there is a way to get LSN of each transaction by directly communicating with Postgres server and NOT by accessing logs.


To what end? What problem are you trying to solve?

What LSN, exactly? The LSN of the first write and xid allocation? The LSN of the commit record? What if it's a complex commit like with prepared xacts?


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Why we lost Uber as a user
Next
From: Greg Stark
Date:
Subject: Re: Detecting skipped data from logical slots (data silently skipped)