| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | bala jayaram <balajayaram22(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: AWS DMS Expecting Logical Replication for Non RDS |
| Date: | 2018-06-05 23:41:40 |
| Message-ID: | 9a04f1d6-00ed-ab05-4e0c-26fb173ac95f@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pavan95 | 2018-06-06 08:53:01 | Re: How to get the postmaster shut downtime dynamically and insert into a table? |
| Previous Message | Magnus Hagander | 2018-06-05 16:42:33 | Re: AWS DMS Expecting Logical Replication for Non RDS |