Re: Logical replication stuck in catchup state - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Logical replication stuck in catchup state
Date
Msg-id 963ab52a-5755-ce1e-738a-60bc05ed73d9@2ndquadrant.com
Whole thread Raw
In response to Logical replication stuck in catchup state  (Dan shmidt <dshmidt@hotmail.com>)
List pgsql-general
On 2020-06-09 23:30, Dan shmidt wrote:
> We have a setup in which there are several master nodes replicating to a 
> single slave/backup node. We are using Postgres 11.4.
> Recently, one of the nodes seems to be stuck and stopped replicating.
> I did some basic troubleshooting and couldn't find the root cause for that.

Have you checked the server logs?  Maybe it has trouble applying a 
change, for example due to a unique constraint or something like that.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Logical replication stuck in catchup state
Next
From: David Rowley
Date:
Subject: Re: Planner misestimation for JOIN with VARCHAR