| Yes, we use physical replication for HA. There are many reasons that cloud providers don't want to support logical replication; - It requires giving superuser access to user. Many cloud providers don't want to give that level of privilege. Some cloud providers fork PostgreSQL or write custom extensions to allow managing replication slots without requiring superuser access. However, doing it securely is very difficult. You suddenly open up a new attack vector for various privilege escalation vulnerabilities. - If user creates a replication slot, but does not consume the changes, it can quickly fill up the disk. I dealt many different failure modes of PostgreSQL, and I can confidently say that disk full cases one of the most problematic/annoying ones to recover from. - It requires careful management of replication slots in case of fail over. There are extensions or 3rd party tools helping with this though. So, some cloud providers don't support logical replication and some support it weakly (i.e. don't cover all edge cases). Thankfully there are some improvements are being done in PostgreSQL core that simplifies failover of logical replication slot (check out this for more information https://www.postgresql.org/docs/17/logical-replication-failo...), but it is still too early. |