Re: AWS DMS Expecting Logical Replication for Non RDS - Mailing list pgsql-admin

From bala jayaram
Subject Re: AWS DMS Expecting Logical Replication for Non RDS
Date
Msg-id CANcY5AwRN3e3tiHa4gRvigU8NT9cOW6Ahgt7k0=wYtymUy0OtQ@mail.gmail.com
Whole thread Raw
In response to AWS DMS Expecting Logical Replication for Non RDS  (bala jayaram <balajayaram22@gmail.com>)
Responses Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS
Re: AWS DMS Expecting Logical Replication for Non RDS
Re: AWS DMS Expecting Logical Replication for Non RDS
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Jorge Torralba
Date:
Subject: Re: PostgreSQL Streaming replication on two diff networks
Next
From: Johannes Truschnigg
Date:
Subject: Re: PostgreSQL Streaming replication on two diff networks