Re: Logical replication stuck in catchup state

2020-06-09 Thread Dan shmidt
Thank you very much for your replies. Regarding the server logs, I didn't find anything but healthy log when the server start which says that it is going to recover from the same point in WAL which was last sent. Regarding bugfixes, I will try to update ASAP - but wouldn't a restart of the serv

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/)-