Thread: AWS DMS Expecting Logical Replication for Non RDS

AWS DMS Expecting Logical Replication for Non RDS

From
bala jayaram
Date:
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

Re: AWS DMS Expecting Logical Replication for Non RDS

From
bala jayaram
Date:
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

Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS

From
gilberto.castillo@etecsa.cu
Date:
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


Re: AWS DMS Expecting Logical Replication for Non RDS

From
Magnus Hagander
Date:
Hi!

This sounds like questions about a proprietary service from AWS. You are probably better off directing your questions to their support, as they have a lot more experience with it.

//Magnus


On Tue, Jun 5, 2018 at 3:41 PM, bala jayaram <balajayaram22@gmail.com> wrote:
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



Re: AWS DMS Expecting Logical Replication for Non RDS

From
Peter Eisentraut
Date:
On 6/5/18 09:41, bala jayaram wrote:
>     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? 

Changing wal_level and max_replication_slots on the standby does not
affect how the primary ships the data.  The setup you are describing
sounds fine.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services