Logical replication from multiple masters - master starvation

2020-08-04 Thread Dan shmidt
Hi everyone, I'm using postgres 11.4 I have a configuration in which there's one subscriber (slave) node which subscribes to several (4) publisher nodes (master). I noticed one of the master servers keeps lagging behind. I noticed that the replication worker on the master keeps failing on timeou

Re: Logical replication stuck in catchup state

2020-06-09 Thread Dan shmidt
art of the server release the lock? Is there a way to release the lock manually? Any other suggestion on how to recover from this state without upgrading? Is there a way to restart the replication from scratch? Sent from Outlook<http://aka.ms/weboutlook> ________ From:

Re: Logical Replication of Multiple Schema Versions

2019-12-11 Thread Dan shmidt
er 11, 2019 6:13 PM To: Dan shmidt ; pgsql-general@lists.postgresql.org Subject: Re: Logical Replication of Multiple Schema Versions On 2019-12-10 08:55, Dan shmidt wrote: > What is the correct way to perform such an operation? > Is there a way to keep constraint #1 or the only option is t

Logical Replication of Multiple Schema Versions

2019-12-09 Thread Dan shmidt
Hi All, Thanks for having such a great mailing list. I hope I'm sending to the correct distribution. I will start with describing my current architecture and where do I use logical replication. I have several nodes each running a postgres-sql database. Each of these nodes has an API server whi