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