On Wed, 5 Sep 2018 13:23:41 +0200 Thomas Poty <thomas.poty@xxxxxxxxx> wrote: > Hi Jehan-Guillaume, Hello, > Thanks for your opinion. > > At first glance, i may use for automatic failover PAF, In fact, PAF does not support slots. So it is not a good candidate if slot are a requirement. > a proxy HAproxy and > for fencincg, i am a bit disappointed, i don't know what to do/use Depend on your hardware or your virtualization technology. > How about you, do you have any preference about tools/solutions to use ? If you want a simple and well community adopted solution, pick Patroni. It deals with slots, rely on etcd or zookeeper, fit nicely with haproxy, deal with watchdog to keep itself under monitor. However, it lacks of fencing and its callback are asynchronous. You would have to take special care of your network and master connectivity upon primary failure. If you want something able to keep multiple services avaliable (PostgreSQL, vIP, storage, pgBouncer, apache, whatever...), deal with dependencies, locations, constraints, rules etc, pick Pacemaker (and a larger coffee machine). I would (obviously) recommend PAF as resource agent for PgSQL, but you would have to design your cluster without slots :/ ++
