Re: pglogical status is down - Mailing list pgsql-admin
Hi Srinivas.
You need to check the PostgreSQL log files to see the problem.
First you can check the logs in Subscriber Instance first. If you not find any, check the Publisher log files.
Have a good luck.
Lucio Chiessi
Senior Database Administrator
Trustly, Inc.
M: +55 27 996360276
PayWithMyBank® is now part of Trustly
On Wed, Feb 8, 2023 at 12:21 AM srinivas oguri <srinivasoguri7@gmail.com> wrote:
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)Can you please help me with this. Does pglogical have any support to stop and start the replication ?ThanksSrinivas
Please read our privacy policy here on how we process your personal data in accordance with the General Data Protection Regulation (EU) 2016/679 (the “GDPR”) and other applicable data protection legislation
pgsql-admin by date: