This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 43%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
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).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
@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
@Mohsen Akhavan Please let us know if you need any further help regarding this,
@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.
@Mohsen Akhavan Logical decoding and Read replicas are options present in Single server as well. Do check them out as well.
@Navtej Singh Saini Thanks I will check it