postgres-ansible

KO | EN

gitlite — search

#python #java #python3 #arduino #golang #machine-learning #rust #html #flask #javascript #seismology #nodejs

postgres-ansible

★ 18 Open GitHub ↗

Ansilbe playbook to deploy HA postgresql with ETCD, Patroni, HAproxy and keepalived

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# postgres-ansible

### Setting up a High Availability (HA) cluster for PostgreSQL with Ansible

```
ansible-playbook -i inventory/db-servers.ini postgres.yml --become --become-method=sudo -t preinstall
```

```
ansible-playbook -i inventory/db-servers.ini postgres.yml --become --become-method=sudo -t postgres
```

```
ansible-playbook -i inventory/db-servers.ini postgres.yml --become --become-method=sudo -t haproxy
```

List your databases:

```
patronictl -c /etc/patroni.yml list
```

+------------------+
                                        |  Client Access   |
                                        +--------+---------+
                                                 |
                                        _________|_________
                            +--------v--------+    +-------+--------+
                            |    HAProxy      |    |    HAProxy     |
                            | (Load Balancer) |    |(Load Balancer) |
                            |       +         |    |       +        |
                            |   pg-bouncer    |    |   pg-bouncer   |
                            +--------+--------+    +--------+-------+
                                     |___________  _______|                                              
                                                 |
                            +--------------------+---------------------+
                            |                    |                     |
                            |                    |                     |
                            v                    v                     v
                    +-------+--------+   +-------+--------+    +-------+--------+
                    |  Server 1      |   |  Server 2      |    |  Server 3      |
                    | (Patroni-etcd) |   | (Patroni-etcd) |    | (Patroni-etcd) |
                    |   Postgresql1  |   |  Postgresql2   |    |  Postgresql3   |
                    +-------+--------+   +-------+--------+    +-------+--------+

Connect to databases:

```
psql -h KEEPALIVE_IP -p 5000 -U postgres
Password for user postgres:

psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1))
Type "help" for help.

```

References:

https://medium.com/@murat.bilal/setting-up-a-postgresql-ha-cluster-0a4348fca444

postgres-ansible

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README