Thread: AWS DMS Expecting Logical Replication for Non RDS
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
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?ThanksBala
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
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?ThanksBalaOn 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?ThanksBala
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