It supports multiple hypervisors including VMWare, KVM, XCP-ng, etc. I haven't tried but it has some features to allow users to migrate from VMWare to Apache CloudStack with KVM and/or XCP-ng.
I wanted to build something like chatGPT but self-hosted without sending my data to OpenAI. This was more of a self-learning project. Haystack made it quite easy for me to get started and build something. Tutorials they have are really good. It still has some bugs but it works.
Thanks for this. As I mentioned in previous comment, I couldn't find much about Stolon.
One of things I likee in stolon is the proxy, it enforce connections to the right PostgreSQL master and forcibly closes connections to unelected masters. Which is not present in Patroni, but I guess it should be doable using consul's service discovery and dynamic DNS. (I am not sure if this can be done using etcd and zookeper).
I am not really sure Patroni has anything to do with the persistence of data. It just uses etcd, zookeper or consul to elect a master in case of a failover and uses their key value store to save the information about the current master. Its upto you whether you keep your database on a container or not. And how the data is managed by the container.
This talk by Josh Berkus explains how Patroni works pretty well.
https://www.youtube.com/watch?v=OH9WSEiMsAw
As per my understanding, Postgres-XL is not comparable to Patroni. Postgres-XL is comparable to PostgreSQL. Postgres-XL shards the data across multiple data nodes. Where as Patroni uses etcd, consul or zookeeper to provide HA for any Postgres cluster using replication (Data is written only to a single instance and replicated further).
I think you meant Stolon. Stolon is quite comparable to Patroni and has more features than Patroni, but I am not sure how many people are using it. I found more resources for Patroni as compared to stolon.
It supports multiple hypervisors including VMWare, KVM, XCP-ng, etc. I haven't tried but it has some features to allow users to migrate from VMWare to Apache CloudStack with KVM and/or XCP-ng.