Sorry I forgot to reply. Thanks! using decoding plugins works great
On Wed, Aug 3, 2016 at 8:37 PM, Michael Paquier <michael.paqu...@gmail.com>
> On Thu, Aug 4, 2016 at 3:02 AM, Joshua Bay <joshuaba...@gmail.com> wrote:
> > Could you please tell me how I can get LSN of each transaction at decoder
> > plugin?
> Craig already gave you hints, but here are more. You will need to hack
> your own plugin. You could just use the one in contrib/test_decoding,
> remove most of its code, and use the commit callback to issue the LSN
> you are interested in. Note as well that when using
> pg_logical_slot_peek_changes or pg_logical_slot_get_changes, you can
> get a LSN location. Using test_decoding as a base, that's not a
> complicated effort.