Hi team,
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)
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