question

MohsenAkhavan avatar image
0 Votes"
MohsenAkhavan asked NavtejSaini-MSFT answered

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

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).

azure-database-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
1 Vote"
NavtejSaini-MSFT answered

@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


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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

0 Votes 0 ·

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


1 Vote 1 ·

@NavtejSaini-MSFT Thanks I will check it

0 Votes 0 ·