AWS DMS Expecting Logical Replication for Non RDS

From: bala jayaram <balajayaram22(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: AWS DMS Expecting Logical Replication for Non RDS
Date: 2018-05-31 18:44:22
Message-ID: CANcY5AzwdC3xZ-u1RtfwLFh+taMYj5j2GzTMMXQEnzezPUF6Kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tal Glozman 2018-06-02 11:06:19 pgAdmin4 3.0 rpm repo for Fedora 28
Previous Message Stéphane KANSCHINE 2018-05-30 13:58:14 Re: pgadmin4 enhancement request: variable path to the config settings