Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS - Mailing list pgsql-admin

From gilberto.castillo@etecsa.cu
Subject Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS
Date
Msg-id ded09d16c554a7ef8f1d9d89fe294a5c@etecsa.cu
Whole thread Raw
In response to Re: AWS DMS Expecting Logical Replication for Non RDS  (bala jayaram <balajayaram22@gmail.com>)
List pgsql-admin
See you, Please

https://medium.com/@gilbertocastillo

El 2018-06-05 09:41, bala jayaram escribió:
> Hi Team,
> 
> Any update on this please?
> 
> Thanks
> Bala
> 
> On Thu, May 31, 2018 at 2:44 PM, bala jayaram
> <balajayaram22@gmail.com> wrote:
> 
>> Hi Team,
>> 
>> Recently we tried to migrate EC2/Postgres with Master/2Slave
>> (Streaming Replication /Hot_standby) into Native RDS based server.
>> But while we try to use Database Migration Service, our aim is to
>> use one of slave as SOURCE for DMS , So AWS/DMS requires that in
>> source machine to be with two parameters changed -
>> max_replication_slot > 0 & wal_level = logical.  If i change those
>> parameters in Slave, will the master will recognize slave with
>> Logical streaming?  Am not sure master with Streaming
>> Replication(Physical) will Sync with Slave with Logical Replication?
>> 
>> 
>> Also if change physical streaming to Logical Streaming, will there
>> be any change in data blocks or data in postgres?
>> 
>> Thanks
>> Bala


pgsql-admin by date:

Previous
From: Johannes Truschnigg
Date:
Subject: Re: PostgreSQL Streaming replication on two diff networks
Next
From: Jorge Torralba
Date:
Subject: Re: PostgreSQL Streaming replication on two diff networks