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. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers