From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: bala jayaram <balajayaram22@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: AWS DMS Expecting Logical Replication for Non RDS
Date: Tue, 5 Jun 2018 19:41:40 -0400
Message-ID: <9a04f1d6-00ed-ab05-4e0c-26fb173ac95f@2ndquadrant.com> (raw)
In-Reply-To: <CANcY5AwRN3e3tiHa4gRvigU8NT9cOW6Ahgt7k0=wYtymUy0OtQ@mail.gmail.com>
References: <CANcY5AzwdC3xZ-u1RtfwLFh+taMYj5j2GzTMMXQEnzezPUF6Kg@mail.gmail.com>
<CANcY5AwRN3e3tiHa4gRvigU8NT9cOW6Ahgt7k0=wYtymUy0OtQ@mail.gmail.com>
On 6/5/18 09:41, bala jayaram wrote:
> 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?
Changing wal_level and max_replication_slots on the standby does not
affect how the primary ships the data. The setup you are describing
sounds fine.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, balajayaram22@gmail.com
Subject: Re: AWS DMS Expecting Logical Replication for Non RDS
In-Reply-To: <9a04f1d6-00ed-ab05-4e0c-26fb173ac95f@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox