My client wants to replicate their on-premise PostgreSQL database and Azure Database for PostgreSQL. The on-premise database is a master and Azure is a slave(read-only). My client wants to sync data in minimum time(etc, 1min).

@Mohsen Akhavan This is currently not possible with Azure Data Sync and please raise this feedback on our User voice so our PG team can check the same. Check this SO issue for further details. Regards Navtej S

Replication solution between on-premise PostgreSQL and Azure database for PostgreSQL

Accepted answer

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-05-13T03:27:15.793+00:00

@Mohsen Akhavan This is currently not possible with Azure Data Sync and please raise this feedback on our User voice so our PG team can check the same.

Check this SO issue for further details.

Regards
Navtej S
Please sign in to rate this answer.

1 person found this answer helpful.
Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-05-14T22:54:32.073+00:00

@Mohsen Akhavan Please let us know if you need any further help regarding this,

Mohsen Akhavan 746 Reputation points

2021-05-16T14:21:26.817+00:00

@Navtej Singh Saini Yes, I checked feedback, but it's not very clear for me. I found logical replication with Azure Postgresql (Flexible) on comments.

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-05-17T22:41:52.827+00:00

@Mohsen Akhavan Logical decoding and Read replicas are options present in Single server as well. Do check them out as well.

Mohsen Akhavan 746 Reputation points

2021-05-18T22:15:50.267+00:00

@Navtej Singh Saini Thanks I will check it
Sign in to comment

Share via

Replication solution between on-premise PostgreSQL and Azure database for PostgreSQL

0 additional answers