pglogical status is down

From: srinivas oguri <srinivasoguri7(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pglogical status is down
Date: 2023-02-08 03:21:05
Message-ID: CADfH0yuNKpyOuAtvT7JN4=a+BDbgyh6XcJ1n6mYJedWmWmrVFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lucio Chiessi 2023-02-08 12:07:36 Re: pglogical status is down
Previous Message Erik Serrano 2023-02-07 21:36:30 Re: Vacuum Full not clean the table