Postgres Pro
Downloads
Home   >   mailing lists

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

From bala jayaram
Subject AWS DMS Expecting Logical Replication for Non RDS
Date
Msg-id CANcY5AzwdC3xZ-u1RtfwLFh+taMYj5j2GzTMMXQEnzezPUF6Kg@mail.gmail.com
Whole thread Raw
Responses Re: AWS DMS Expecting Logical Replication for Non RDS  (bala jayaram <balajayaram22@gmail.com>)
List pgsql-admin
Tree view
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: Stéphane KANSCHINE
Date:
Subject: Re: pgadmin4 enhancement request: variable path to the configsettings
Next
From: Tal Glozman
Date:
Subject: pgAdmin4 3.0 rpm repo for Fedora 28