docker postgresql patroni 🍃

Herkese Merhablar , Dokcer üzerinde postresql patroni kurulumu hızlaca komutlarını verip bırakacağım lafı çok uzatmadan :)

3 patroni — 3 etcd — 1 haproxy şeklinde kurulum olucak direkt kopyala yapıştır tarzında

git clone https://github.com/patroni/patroni.git
cd patroni
docker build -t patroni .
docker build -f Dockerfile.citus -t patroni-citus .
docker run -d patroni
docker compose up -d

Bağlanmak için

docker exec -ti demo-patroni1 bash
postgres@patroni1:~$ patronictl list
+ Cluster: demo (7455763978412507159) ------+----+-----------+
| Member   | Host       | Role    | State   | TL | Lag in MB |
+----------+------------+---------+---------+----+-----------+
| patroni1 | 172.26.0.2 | Replica | running |  1 |         0 |
| patroni2 | 172.26.0.3 | Leader  | running |  1 |           |
| patroni3 | 172.26.0.6 | Replica | running |  1 |        16 |
+----------+------------+---------+---------+----+-----------+

etcd durumları

postgres@patroni1:~$ etcdctl member list
1bab629f01fa9065, started, etcd3, http://etcd3:2380, http://172.26.0.4:2379
8ecb6af518d241cc, started, etcd2, http://etcd2:2380, http://172.26.0.5:2379
b2e169fcb8a34028, started, etcd1, http://etcd1:2380, http://172.26.0.7:2379


haproxy üzerinde bağlanmak

ibrahimyildiz@192 patroni % docker exec -ti demo-haproxy bash
postgres@haproxy:~$ psql -h localhost -p 5000 -U postgres -W
Password:postgres 
psql (16.6 (Debian 16.6-1.pgdg120+1))
Type "help" for help.