Postgres Pro
Downloads
Home   >   mailing lists

Thread: pglogical status is down

pglogical status is down

From
srinivas oguri
Date:
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 ?

Thanks
Srinivas

Re: pglogical status is down

From
Lucio Chiessi
Date:
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 ?

Thanks
Srinivas

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