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