Re: pglogical status is down

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

<https://www.linkedin.com/company/trustly/>
<https://www.facebook.com/trustly> <https://twitter.com/Trustly>

<https://www.linkedin.com/company/trustly/>
<https://www.facebook.com/trustly> <https://twitter.com/Trustly>

<https://www.trustly.net/>

PayWith*MyBank®* is now part of *Trustly*

On Wed, Feb 8, 2023 at 12:21 AM srinivas oguri <srinivasoguri7(at)gmail(dot)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
<https://www.trustly.net/about-us/privacy-policy> 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