stolon-chart VS patroni

stolon-chart

We haven't tracked posts mentioning stolon-chart yet.
Tracking mentions began in Dec 2020.

patroni

• How to create postgres cluster in docker swarm?
  3 projects | /r/node | 18 Jun 2023

  We have been using stolon + consul for years without issue in our swarm environments. It may also be possible with patroni.

• Why PostgreSQL High Availability Matters and How to Achieve It
  4 projects | news.ycombinator.com | 14 Jun 2023

  one of the solutions which made it pretty simple for us to run postgresql in a ha environment (mostly in k8s, but works standalone as well) is zalandos patroni: https://github.com/zalando/patroni it's really solid and worked for us for a few years already.

  or for k8s their operator: https://github.com/zalando/postgres-operator (docker image: https://github.com/zalando/spilo) we've also tried other operators which were easier to get started, but they failed miserably (crunchyrolls operator is basically based on the zalando one)

• Docker: Patroni + HAProxy + Etcd + PgBouncer
  2 projects | /r/PostgreSQL | 28 Mar 2023

  Hello. I am currently using this docker-compose model from Zalando repository. It does not include PgBouncer in its architecture by default. I've been trying to find a containerized implementation involving Patroni, HAProxy, Etcd and PgBouncer. I didn't find anything solid so far.

• Can someone share experience configuring Highly Available PgSQL?
  8 projects | /r/PostgreSQL | 26 Mar 2023

  General purpose: Patroni - Set up your own etcd + HAProxy + Patroni + Postgres components and it'll generally manage itself after that.

• Any self hostable postgres clustering, replication and fail over system?
  3 projects | /r/PostgreSQL | 25 Jan 2023
• GCP Cloud SQL Migration without outage?
  2 projects | /r/sre | 17 Dec 2021

  This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).

• PostgreSQL 14 Released
  14 projects | news.ycombinator.com | 30 Sep 2021
• Vitess 11
  4 projects | news.ycombinator.com | 29 Jul 2021
• How can I check the load of the PostgreSQL container?
  3 projects | /r/PostgreSQL | 24 Jun 2021

  Want a tool for increasing the durability of your DB? I suggest running postgres via systemd, or failing that, start-stop-daemon. To get even more robust, look in to something like setting up pgbouncer in front of haproxy in front of a set of read-only replica PG instances running in either logical or streaming replication. To get even MORE robust, I suggest Patroni for high-availability PG.

• PostgreSQL High availability
  3 projects | /r/PostgreSQL | 11 Jan 2021

  see here - https://github.com/zalando/patroni