Hi,
We get error loading changes from replication slot
select * from pg_replication_slots ;
slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
-----------------+-------------+-----------+--------+----------+-----------+--------+------------+--------+--------------+-------------+---------------------
lon_walslot_raw | decoder_raw | logical | 16385 | glftest | f | f | [null] | [null] | 139364 | 0/4FBC6B48 | 0/510FF0F8
Select * FROM pg_logical_slot_get_changes('lon_walslot_raw', NULL, NULL) ;
result in
ERROR: subtransaction logged without previous top-level txn record
How can we fix this ?
Thanks
SB
This message is for the recipients only. If you receive it in error, please notify the sender and delete it together with any attachments. Please refer to our client-supplier disclosure on https://www.savinodelbene.com/en/privacy/