Re: [GENERAL] Schema/table replication

> On Sep 6, 2017, at 8:48 AM, Marcin Giedz <marcin.giedz@arise.pl> wrote:
>
> Does pglogical support views replication as I can't find it in any restrictions ?

There's no need to replicate the contents of a view, as it doesn't contain any data.

pglogical can replicate the initial schema, including any views, but won't replicate DDL changes automatically after
that.It does provide a clean way to replicate DDL from the master to slaves with pglogical.replicate_ddl_command(). 

Cheers,
  Steve

> > On Sep 6, 2017, at 6:00 AM, Marcin Giedz <marcin.giedz@arise.pl> wrote:
> >
> > Hi, is there any way (3rd party software) to replicate particular schema/table not the whole database with
streamingreplication built-in mechanism ? 
>
> I don't believe so. You can do that with logical replication in v10 -
https://www.postgresql.org/docs/10/static/logical-replication.html.
>
> pglogical will give you much the same functionality on current releases.
https://www.2ndquadrant.com/en/resources/pglogical/- installation isn't too painful (though the docs are a little
sparsewhen it comes to which node you should run which command on. Make the postgres.conf changes on master and slave
nodes,as slave nodes need replication slots too(?)). 
>
> There are a bunch of trigger-based replication frameworks that'll work too, though less efficiently - Slony is widely
used,and I used Bucardo successfully for years before moving to pglogical. 
>
> Cheers,
>   Steve
>
>