Re: Feature Request - DDL deployment with logical replication

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(dot)knizhnik(at)postgrespro(dot)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