Re: DDL support for logical replication

2019-10-10 Thread Jeremy Finzel
On Thu, Oct 10, 2019 at 3:09 PM Lev Kokotov wrote: > Hi Miles, > > One issue is keeping the subscriber and the publisher schema identical. > Running migrations on both the publisher and subscriber does not seem > atomic to me, therefore I don't have a way to enforce consistency between > the two.

Re: DDL support for logical replication

2019-10-10 Thread Cory Nemelka
Another use case is installations where there is heavy reliance on temporary tables in queries. Since you can't run queries that create temporary tables on servers that are binary replicas, this leaves the master (not horizontally scalable) or logical replicas --cnemelka On Thu, Oct 10, 2019 a

Re: DDL support for logical replication

2019-10-10 Thread Lev Kokotov
Hi Miles, One issue is keeping the subscriber and the publisher schema identical. Running migrations on both the publisher and subscriber does not seem atomic to me, therefore I don't have a way to enforce consistency between the two. The use case is simple: schemas change all the time, and keepin

Re: DDL support for logical replication

2019-10-10 Thread Miles Elam
Hi Lev, While I don't have an answer to your roadmap question, you've raised a different question for me. What are you expecting to get from logical replication of DDL commands that is not served by binary replication? I ask because typically someone would want to use logical replication if they

DDL support for logical replication

2019-10-10 Thread Lev Kokotov
Hello, Is DDL support on a roadmap for logical replication? Thank you. - Lev