On 3 August 2016 at 11:37, Joshua Bay <joshuabay93(at)gmail(dot)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