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

Re: Logical Replication of Multiple Schema Versions

2019-12-11 Thread Peter Eisentraut
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 to not allow "breaking" schema changes between versions. It all depends on the specific schema changes you want to make. You can add columns

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