pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: AWS DMS Expecting Logical Replication for Non RDS
4+ messages / 4 participants
[nested] [flat]
* Re: AWS DMS Expecting Logical Replication for Non RDS
@ 2018-06-05 13:41 bala jayaram <balajayaram22@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: bala jayaram @ 2018-06-05 13:41 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
Any update on this please?
Thanks
Bala
On Thu, May 31, 2018 at 2:44 PM, bala jayaram <balajayaram22@gmail.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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS
@ 2018-06-05 13:44 gilberto.castillo@etecsa.cu
parent: bala jayaram <balajayaram22@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: gilberto.castillo@etecsa.cu @ 2018-06-05 13:44 UTC (permalink / raw)
To: bala jayaram <balajayaram22@gmail.com>; +Cc: pgsql-admin
See you, Please
https://medium.com/@gilbertocastillo
El 2018-06-05 09:41, bala jayaram escribió:
> Hi Team,
>
> Any update on this please?
>
> Thanks
> Bala
>
> On Thu, May 31, 2018 at 2:44 PM, bala jayaram
> <balajayaram22@gmail.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: AWS DMS Expecting Logical Replication for Non RDS
@ 2018-06-05 16:42 Magnus Hagander <magnus@hagander.net>
parent: bala jayaram <balajayaram22@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2018-06-05 16:42 UTC (permalink / raw)
To: bala jayaram <balajayaram22@gmail.com>; +Cc: pgsql-admin
Hi!
This sounds like questions about a proprietary service from AWS. You are
probably better off directing your questions to their support, as they have
a lot more experience with it.
//Magnus
On Tue, Jun 5, 2018 at 3:41 PM, bala jayaram <balajayaram22@gmail.com>
wrote:
> Hi Team,
>
> Any update on this please?
>
> Thanks
> Bala
>
> On Thu, May 31, 2018 at 2:44 PM, bala jayaram <balajayaram22@gmail.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
>>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: AWS DMS Expecting Logical Replication for Non RDS
@ 2018-06-05 23:41 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: bala jayaram <balajayaram22@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2018-06-05 23:41 UTC (permalink / raw)
To: bala jayaram <balajayaram22@gmail.com>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-06-05 23:41 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-06-05 13:41 Re: AWS DMS Expecting Logical Replication for Non RDS bala jayaram <balajayaram22@gmail.com>
2018-06-05 13:44 ` gilberto.castillo@etecsa.cu
2018-06-05 16:42 ` Magnus Hagander <magnus@hagander.net>
2018-06-05 23:41 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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