Re: AWS DMS Expecting Logical Replication for Non RDS

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