Azure postgres - how to use read replica,logical replication for online migration

Question

Hi,

I have source as azure database for postgres(single server) and i wish to move to another azure postgres as target(single server ) using DMS online migration. We have a active read replica already created for source for reporting workload. For DMS to work, as per the documentation, we have to enable logical replication to do the continuous sync. Now in this scenario, if i want to DMS to work(by enabling logical replication), do i have to turn off read replica?. If yes, how do we ensure read replica is serving reporting workloads when we are actively using DMS to do online sync to target postgres?

Answer 1

Hi @sql user , welcome to Microsoft Q&A forum.

Read replicas work both with 'Replica' and 'Logical' replication. You can refer to below article for more details:

Azure replication support

So while migrating with DMS we need not to worry about if we set it to any of these 2 values.

Please let me know if this helps or else we can discuss further. If answer helps, you can mark it 'Accept Answer.'