Questions tagged [patroni]
8 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
- 51
- 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
- 333
- 3
- 8
- 31
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
- 51
- 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
- 31
- 1
- 2
0
votes
1 answer
Patroni interconnection failover
3 Data Centres:
Patroni version: 2.1.4
PostgreSQL version: 14.4
Etcd version: 3.3.11
DC
Server
Name
Host
Status
1st
Patroni
patroni-s11
172.16.0.2
Leader
1st
Patroni
patroni-s12
172.16.0.3
Sync…
EcksRay
- 1
0
votes
1 answer
Patroni Haproxy and pg-bouncer architecture
I'm building a patroni postgres cluster, however, I can't decide which is better architecture
App > HAproxy > Pgbouncer > PostgreSQL (patroni)
App > PGBouncer > HAproxy > PostgreSQL (patroni)
I can't seem to get an answer upon my search and a lot of…
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
- 51
- 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
- 143
- 2
- 9