CyberDem0n

4 ms·

1.
by CyberDem0n 5y ago
It's not enough to intercept `set search_path`, in fact any arbitrary function could change it, but Postgres doesn't report it back, unlike some other gucs.
2.
by CyberDem0n 6y ago
Patroni was openly developed from day 0. The repo was created in early July 2015, but before that it was living as the fork of Compose Governor. The Spilo docker container which packages PostgreSQL + Patroni was also always publicly availab
3.
by CyberDem0n 9y ago
> if you accessing the DB but can't contact etcd/consul then you should stop accessing the DB because you might start doing unsafe writes. If patroni can't update leader lock in Etcd, it will restart postgres in read-only
4.
by CyberDem0n 9y ago
> well I think that is not the same what stolon-proxy actually provides. (actually I use patroni) but if your network gets split and you end up with two masters (one application writes to the old master) there would be a problem if one a
5.
by CyberDem0n 9y ago
It looks like you are talking here about postgres-operator by Crunchy Yeah, crunchy was a little faster with releasing it than Zalando, but try you look closer how they deploy postgres on kubernetes. Somehow it feels that they are trying to
6.
by CyberDem0n 9y ago
> I currently prefer Stolon over Patroni because statically typed languages make it easier to have less bugs (Stolon is Go, Patroni is Python) Sounds like a holy-war topic :) But lets be serious. How statically typed language helps you t
7.
by CyberDem0n 9y ago
Correct. Writes need to be directed to master. May be not only writes but some reads as well. Only application can know which statement can be executed on replicas and which must be executed on master.
8.
by CyberDem0n 9y ago
You also can have a look on slides of my talk about at PGConf.US 2017: https://www.slideshare.net/AlexanderKukushkin1/patroni-ha-po... Talk was also recorded but video is not yet published. And one more thing, you can
9.
by CyberDem0n 9y ago
Patroni has REST API providing a health-checks for load-balancers. patroni:8008/replica will respond with http status code 200 only if node is running as replica. In the HAProxy config file you just need to list all Patroni nodes, spec
10.
by CyberDem0n 9y ago
Compose guys are kind of happy with existing functionality of Governor and didn't really wanted to add something new. That was the main reason of making a fork. If you read a further comments to this news you can get familiar with the
11.
by CyberDem0n 9y ago
on-marked-down shutdown-sessions should do the trick
12.
by CyberDem0n 9y ago
Doesn't HAProxy provide such functionality? Patroni has REST API which can be used by HAProxy for a health-check. patroni:8008/master will return http status code 200 only if the node running as elected master patroni:8008/re
13.
by CyberDem0n 9y ago
> Stolon is quite comparable to Patroni and has more features than Patron. Let me as a question, what feature Stolon has and Patroni doesn't? Can you give an example? From my side I can provide list of features available in Patroni,
14.
by CyberDem0n 10y ago
Yes, one can reimplement it in Python, but don't forget: // This implementation does not guarantee that only one client is acting as a // leader (a.k.a. fencing). A client observes timestamps captured locally to &#x