I am using a pglogical extension for logical replication from Aurora PostgreSQL version 12 to Linux Community PostgreSQL 12 version. While the replication is going on the Linux machine got rebooted and the replication did not start again.
pylon=# select pglogical.alter_subscription_synchronize('subscription1'); alter_subscription_synchronize -------------------------------- t (1 row)
pylon=# SELECT subscription_name, status FROM pglogical.show_subscription_status(); subscription_name | status -------------------+-------- subscription1 | down (1 row)
Can you please help me with this. Does pglogical have any support to stop and start the replication ?
Thanks
Srinivas
Please read our privacy policy hereon how we process your personal data in accordancewiththeGeneral Data Protection Regulation(EU) 2016/679 (the “GDPR”) and other applicable data protection legislation