From: | Silvio Brandani - SDB Information Technology Srl <silvio(dot)brandani(at)tech(dot)sdb(dot)it> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | ERROR: subtransaction logged without previous top-level txn record |
Date: | 2019-04-09 14:11:30 |
Message-ID: | DB7PR04MB510030498CB46121650A1C20BD2D0@DB7PR04MB5100.eurprd04.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter M. Groen | 2019-04-09 16:07:19 | Re: How to insert from linux to postgreSQL |
Previous Message | Rui DeSousa | 2019-04-08 19:33:42 | Re: How to insert from linux to postgreSQL |