I want to build a highly available PostgreSQL cluster using patroni with etcd. I want to have 3 server (1 master and 2 slaves) in my cluster, so if something goes wrong one of the slaves automatically takes over the master role. Only the master server should accept write operators, the slaves are only for safety and read operations.

On the other hand i also need approximately 10 servers with an up-to-date copy of the data on the cluster. These servers are only there to read data and none of them ever can be promoted to a master server. They shouldn't even be part of the high available cluster. They are just supposed to get the data using streaming replication etc.

Is such a setup even possible? Can i use replication to other servers when they are part of a patroni cluster?

  • 1
    To my knowledge Patroni uses streaming replication as well, it essentially coordinates the failover, not the replication itself. I don't see any reason why you couldn't have additional standby servers that are not under the control of Patroni (but I have never used Patroni, so I can't really tell) – a_horse_with_no_name Sep 1 at 10:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.