Share via

Azure Postgresql flexible server - external streaming replication

Salil Nataraja Pillai 1 Reputation point
2022-05-20T08:53:59.883+00:00

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 for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,967 Reputation points Microsoft Employee
    2022-05-20T16:13:58.68+00:00

    Hi, @Salil Nataraja Pillai 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