Re: 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: Re: AWS DMS Expecting Logical Replication for Non RDS
Date: 2018-06-05 13:41:00
Message-ID: CANcY5AwRN3e3tiHa4gRvigU8NT9cOW6Ahgt7k0=wYtymUy0OtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

Any update on this please?

Thanks
Bala

On Thu, May 31, 2018 at 2:44 PM, bala jayaram <balajayaram22(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Johannes Truschnigg 2018-06-05 13:43:55 Re: PostgreSQL Streaming replication on two diff networks
Previous Message Jorge Torralba 2018-06-05 13:39:42 Re: PostgreSQL Streaming replication on two diff networks