How cherif47/cluster_pgsql_docker works
This repository is an Ansible deployment for a three-node Docker Swarm hosting etcd and a Patroni-managed PostgreSQL 18 cluster, plus Portainer, PgBouncer, and a HAProxy/Keepalived virtual-IP entry point. An operator runs playbook.yml; its documented plays bootstrap hosts, install Docker, form the Swarm, prepare nodes, then deploy services. The graph follows those documented responsibilities and major capabilities. Source excerpts were unavailable, so relationships are limited to those stated in the README; implementation details within the roles are not inferred.
Main entry points: playbook.yml Deployment plays · tasks/main.yml Portainer deployment · tasks/main.yml etcd deployment · etcd-stack.yml etcd stack
Components 21
Deployment orchestration
- Deployment plays
playbook.yml - Host inventory
inventory.ini - Shared settings
group_vars/all/vars.yml
Host and Swarm
- Host bootstrap
roles/bootstrap/tasks/main.yml - Docker installation
roles/docker/tasks/main.yml - Swarm initialization
roles/swarm-manager/tasks/main.yml - Manager joining
roles/swarm-join-manager/tasks/main.yml
Database platform
- Node preparation
roles/node_prepare/tasks/main.yml - etcd deployment
roles/etcd/tasks/main.yml - etcd stack
files/etcd-stack.yml - etcd cluster
- Patroni deployment
roles/patroni/tasks/main.yml - Patroni stack
files/patroni-stack.yml - PostgreSQL HA
Access and management
- PgBouncer
roles/pgbouncer/tasks/main.yml - Portainer deployment
roles/portainer/tasks/main.yml - Portainer agent stack
files/portainer-agent.yml - Portainer server stack
files/portainer-stack.yml - HAProxy
roles/haproxy/tasks/main.yml - Keepalived VIP
roles/keepalived/tasks/main.yml
Other components
- Operator
Connections 20
- Operator → Deployment plays: runs
README.md - Deployment plays → Host inventory: targets hosts
README.md - Deployment plays → Shared settings: uses settings
README.md - Deployment plays → Host bootstrap: runs first
README.md - Deployment plays → Docker installation: installs Docker
README.md - Deployment plays → Swarm initialization: initializes Swarm
README.md - Deployment plays → Manager joining: joins managers
README.md - Deployment plays → Node preparation: prepares nodes
README.md - Deployment plays → etcd deployment: deploys etcd
README.md - etcd deployment → etcd stack: deploys stack
README.md - etcd stack → etcd cluster: defines services
README.md - Deployment plays → Patroni deployment: deploys Patroni
README.md - Patroni deployment → Patroni stack: deploys stack
README.md - Patroni stack → PostgreSQL HA: defines services
README.md - Deployment plays → Portainer deployment: deploys Portainer
README.md - Portainer deployment → Portainer agent stack: deploys agent
README.md - Portainer deployment → Portainer server stack: deploys server
README.md - Deployment plays → PgBouncer: deploys PgBouncer
README.md - Deployment plays → HAProxy: deploys HAProxy
README.md - Deployment plays → Keepalived VIP: deploys Keepalived
README.md