Re: Logical replication stuck in catchup state

2020-06-09 Thread Dan shmidt
Dan shmidt Sent: Wednesday, June 10, 2020 12:30 AM To: pgsql-gene...@postgresql.org Subject: Logical replication stuck in catchup state Hi All, 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 n

Re: Logical replication stuck in catchup state

2020-06-09 Thread Peter Eisentraut
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

Re: Logical replication stuck in catchup state

2020-06-09 Thread Michael Lewis
I don't know if it would be relevant to this problem, but you are missing almost 1 full year of bug fixes. 11.4 was released on 20 June last year. Upgrading minor versions asap is recommended. I do see this in the release notes from 11.8 last month ( https://www.postgresql.org/docs/release/11.8/)-