How to overcome unavailablity of replication slots in HA standby in Postgres Flexible server

Mani Mahesh Sivakumar 56 Reputation points
2022-10-03T06:42:56.553+00:00

As Per our client recommendation, we need to have read replica in our db architecture. We are using Postgres Flexible server in HA setup. For creating read replica, we have done POC on logical replication using pg_logical . As there is limitation of unavailability of replication slots in standby server. What is the workaround need to be done in read replica(Subscriber) to avoid data loss in replication. Kindly suggest a solution with steps.

Azure Database for PostgreSQL
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
    2022-10-03T17:19:54.04+00:00

    Hi, @Mani Mahesh Sivakumar Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.
    Unfortunately, It is a Postgres limitation and we don’t have an ETA at this on when the limitation will be lifted. After a HA failover, the logical standby has to be manually recreated.

    If you are interested in (Disaster Recovery) DR, you can look into “read replica” feature – which is currently in private preview. We plan to bring that to public preview soon.
    please let me know if you are interested to enroll in Private preview.

    Hope this information helps.
    Regards
    Geetha