Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [patroni]

7 questions
2
votes
1 answer

patroni.exceptions.PatroniFatalException: 'Failed to bootstrap cluster'

I have a problem with patroni right here [postgres@localhost ~]$ patroni /etc/patroni.yml 2021-05-25 11:39:56,767 INFO: Selected new etcd server http://10.102.196.138:2379 2021-05-25 11:39:56,772 INFO: No PostgreSQL configuration items changed,…
Tùng Nguyễn
  • 33
  • 1
  • 5
2
votes
1 answer

Add 3rd server with pglogical replication to a 2 server cluster with stream sync replication and failsafe with patroni

I have 3 servers with Ubuntu 19.10, PostgreSQL 12.2 and Patroni 1.6.4 and I would like to have the following setup: I want to have two servers with synchronised replication and I want to add a 3rd server with pglogical replication just to accept…
ufk
  • 323
  • 3
  • 7
  • 26
1
vote
0 answers

yaml.parser.ParserError: while parsing a block mapping

I followed this document while configuring patroni and I have a problem with patroni.service file like this https://snapshooter.com/learn/postgresql/postgresql-cluster-patroni [Unit] Description=Runners to orchestrate a high-availability…
Tùng Nguyễn
  • 33
  • 1
  • 5
1
vote
0 answers

How to setup/make Haproxy send read-write request based on REST method

How to setup/make Haproxy send read-write request coming on same port 5432 from application, to backend servers of postgres-patroni cluster based on REST method. I have three node postgres-patroni cluster running as docker service/containers behind…
charlie
  • 21
  • 2
0
votes
0 answers

how install and run haproxy postgres and patroni under docker

I'm trying to run haproxy on a docker, but it doesn't work. 1-I create haproxy.cfg under /etc/haproxy/haproxy.cfg: global log 127.0.0.1 local2 chroot /var/lib/haproxy pidfile /var/run/haproxy.pid user haproxy group …
ksalhi
  • 1
  • 1
0
votes
1 answer

Centos 7, HA postgresql12, patroni with etcd v3.4

I followed this document but dont know how to enable v2 so that patroni can work with, can anyone help? https://computingforgeeks.com/setup-etcd-cluster-on-centos-debian-ubuntu/
Tùng Nguyễn
  • 33
  • 1
  • 5
0
votes
1 answer

Patroni Postgres Cluster, what does 'TL' mean in the output of 'patronictl list'

Executing. patronictl list Produces + Cluster: psql-core03-uat-kong (6867488892458676291) ------+----+-----------+ | Member | Host | Role | State | TL | Lag in MB…
englishPete
  • 123
  • 8