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
