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).
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).
@MohsenAkhavan 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
@MohsenAkhavan Please let us know if you need any further help regarding this,
@NavtejSaini-MSFT Yes, I checked feedback, but it's not very clear for me. I found logical replication with Azure Postgresql (Flexible) on comments.
@MohsenAkhavan Logical decoding and Read replicas are options present in Single server as well. Do check them out as well.
3 people are following this question.