Re: [GENERAL] Schema/table replication

2017-09-06 Thread Nico Williams
On Wed, Sep 06, 2017 at 08:22:14AM -0700, Steve Atkins wrote: > > On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote: > > > > Hi, is there any way (3rd party software) to replicate particular > > schema/table not the whole database with streaming replication built-in > > mechanism ? > > I don't be

Re: [GENERAL] Schema/table replication

2017-09-06 Thread Steve Atkins
> On Sep 6, 2017, at 8:48 AM, Marcin Giedz 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

Re: [GENERAL] Schema/table replication

2017-09-06 Thread Marcin Giedz
Does pglogical support views replication as I can't find it in any restrictions ? Thx Marcin Od: "Steve Atkins" Do: pgsql-general@postgresql.org Wysłane: środa, 6 wrzesień 2017 17:22:14 Temat: Re: [GENERAL] Schema/table replication > On Sep 6, 2017, at 6:00 AM, M

Re: [GENERAL] Schema/table replication

2017-09-06 Thread Steve Atkins
> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote: > > Hi, is there any way (3rd party software) to replicate particular > schema/table not the whole database with streaming replication built-in > mechanism ? I don't believe so. You can do that with logical replication in v10 - https://www.po

[GENERAL] Schema/table replication

2017-09-06 Thread Marcin Giedz
Hi, is there any way (3rd party software) to replicate particular schema/table not the whole database with streaming replication built-in mechanism ? Thx Marcin