Re: Using logical replication with older version subscribers

2019-01-08 Thread Masahiko Sawada
On Tue, Jan 8, 2019 at 1:12 AM Magnus Hagander wrote: > > On Mon, Jan 7, 2019 at 3:37 PM Masahiko Sawada wrote: >> >> On Mon, Jan 7, 2019 at 6:54 PM Magnus Hagander wrote: >> > >> > On Mon, Jan 7, 2019 at 9:01 AM Masahiko Sawada >> > wrote: >> >> >> >> Hi, >> >> >> >> Logical replication enabl

Re: Using logical replication with older version subscribers

2019-01-07 Thread Magnus Hagander
On Mon, Jan 7, 2019 at 3:37 PM Masahiko Sawada wrote: > On Mon, Jan 7, 2019 at 6:54 PM Magnus Hagander > wrote: > > > > On Mon, Jan 7, 2019 at 9:01 AM Masahiko Sawada > wrote: > >> > >> Hi, > >> > >> Logical replication enables us to replicate data changes to different > >> major version Postgr

Re: Using logical replication with older version subscribers

2019-01-07 Thread Masahiko Sawada
On Mon, Jan 7, 2019 at 6:54 PM Magnus Hagander wrote: > > On Mon, Jan 7, 2019 at 9:01 AM Masahiko Sawada wrote: >> >> Hi, >> >> Logical replication enables us to replicate data changes to different >> major version PostgreSQL as the doc says[1]. However the current >> logical replication can work

Re: Using logical replication with older version subscribers

2019-01-07 Thread Peter Eisentraut
On 07/01/2019 10:54, Magnus Hagander wrote: > I assume you are not suggesting a publication with truncation enabled > should just ignore replicating truncation if the downstream server > doesn't support it? Because if that's the suggestion, then a strong -1 > from me on that.  Yes, that's the reas

Re: Using logical replication with older version subscribers

2019-01-07 Thread Magnus Hagander
On Mon, Jan 7, 2019 at 9:01 AM Masahiko Sawada wrote: > Hi, > > Logical replication enables us to replicate data changes to different > major version PostgreSQL as the doc says[1]. However the current > logical replication can work fine only if replicating to a newer major > version PostgreSQL su

Using logical replication with older version subscribers

2019-01-07 Thread Masahiko Sawada
Hi, Logical replication enables us to replicate data changes to different major version PostgreSQL as the doc says[1]. However the current logical replication can work fine only if replicating to a newer major version PostgreSQL such as from 10 to 11. Regarding using logical replication with older