On Fri, Mar 30, 2018 at 09:38:44AM +0200, Chris Travers wrote: > On Fri, Mar 30, 2018 at 9:26 AM, Konstantin Knizhnik < > k.knizh...@postgrespro.ru> wrote: > > > Our team in PostgresPro is also very interested in this discussion, > > because we are using logical decoding in multimaster. > > Right now in multimaster DDLs are replicated in this same way as in > > pglogical, using "logical messages" with correspondent DDL statements. > > There are a couple of problems related with this approach, for example mix > > of DDL with DML (create table as...) which we have addressed in multimaster. > > > > As an alternative we have considered possibility to replicate updates of > > catalog tables. In this case we need to address the following issues: > > 1. Map OIDs > > 2. Perform direct manipulation with files (i.e. truncate, alter table,...) > > > > One very important note here is that since truncate is not replicated there > are cases where people are relying on current behaviour. For example, we > are going to use logical replication specifically for this reason as a way > of replacing our current FDW-based push approach. If truncate is ever > replicated, it would be really nice to be able to specify not to replicate > it on the subscription level.
Do you have some kind of API in mind for describing subscriptions? Best, David. -- David Fetter <david(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
