question

SalilNatarajaPillai-5982 avatar image
0 Votes"
SalilNatarajaPillai-5982 asked GeethaThatipatri-MSFT commented

Azure Postgresql flexible server - external streaming replication

We have PostgreSQL database running in Azure PostgreSQL flexible server. We want to replicate the database to an external Azure VM with PostgreSQL using streaming replication. Is this supported?

We have tried logical replication but that will not work for us since it fails during database failover as the standby is not maintaining replication slots.


azure-database-postgresql
· 1
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.

I think this is not supported. As I tried different ways to do it for roblox so the work could be done easily. I also consultant to different expert even national and international. But haven't got the solution if you found any solution so kindly do share with me.


0 Votes 0 ·

1 Answer

GeethaThatipatri-MSFT avatar image
0 Votes"
GeethaThatipatri-MSFT answered GeethaThatipatri-MSFT commented

Hi, @SalilNatarajaPillai-5982 Welcome to the Microsoft Q&A forum, and thanks for reaching out.
As we understand the ask here is that you want to replicate the database to an external Azure VM with PostgreSQL using streaming replication. and you want to know if this is supported.
Unfortunately, Streaming replication is not yet supported that is because Azure PG has additional internal DBs and hence doesn't work. you can do logical/pglogical/logical decoding replication.
Looks like you have set up HA on Flex If so, I don't think there is no alternative at this time. But if you don't have HA setup on Flex, you could use logical replication.

Please let me know if you need any additional information.

Regards
Geetha

· 1
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.

Hi, @SalilNatarajaPillai-5982 We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

0 Votes 0 ·