On 4 August 2016 at 01:35, Joshua Bay <joshuabay93(at)gmail(dot)com> wrote:
> Thanks for responses!
>
> The problem I wanted to solve was to find the (global) order of commits
> across the postgres cluster. So, my attempt was to use the LSN.
>
Have a look at how logical decoding does it. Check out ReorderBufferCommit
in src/backend/replication/logical/reorderbuffer.c .
Or just write a trivial a logical decoding plugin that only implements the
commit callback and only emits the LSN.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services