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

From Magnus Hagander
Subject Re: AWS DMS Expecting Logical Replication for Non RDS
Date
Msg-id CABUevEwd0fq=_1icz2171d26wmTM8Coji-L8PhMRhvX1Eqm8_Q@mail.gmail.com
Whole thread Raw
In response to Re: AWS DMS Expecting Logical Replication for Non RDS  (bala jayaram <balajayaram22@gmail.com>)
List pgsql-admin
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?

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: Shreeyansh Dba
Date:
Subject: Re: pgpool-II with PostgreSQL Streaming replication
Next
From: Peter Eisentraut
Date:
Subject: Re: AWS DMS Expecting Logical Replication for Non RDS