On 18 March 2015 at 21:47, Ruth Melendo <rmelendo@xxxxxxxxxxxx> wrote:
I don’t get this about the "peek" functions not the "get" functions .. What do you mean?
See:
http://www.postgresql.org/docs/current/static/logicaldecoding.html
http://www.postgresql.org/docs/current/static/logicaldecoding-sql.html
http://www.postgresql.org/docs/current/static/logicaldecoding.html
http://www.postgresql.org/docs/current/static/logicaldecoding-sql.html
You used pg_logical_slot_get_binary_changes . This consumes changes from the slot. Don't do that on a slot used by something else. Use pg_logical_slot_peek_changes or pg_logical_slot_peek_binary_changes .
--
