Skip to content

Ansible role for a database cluster using Postgres (11), Pgpool2 (4.0) and Debian (10).

License

Notifications You must be signed in to change notification settings

jobcespedes/pg_cluster

Folders and files

NameName
Last commit message
Last commit date
Jun 16, 2020
Feb 15, 2021
May 22, 2020
Aug 28, 2020
Feb 15, 2021
Jun 16, 2020
Nov 4, 2020
Aug 28, 2020
May 14, 2020
May 14, 2020
Aug 28, 2020
May 14, 2020
May 22, 2020

Repository files navigation

Role Name: pg_cluster

Build Status Buy me a coffee

A database cluster using Postgres (11), Pgpool2 (4.0) and Debian (10).

The cluster has 3 nodes. Each node runs Pgpool2 and Postgres. Pgpool2 and Postgres have two roles each. For Postgres, those roles are: primary and standby. For Pgpool2, those roles are: active and stanby. Pgpool and Postgres roles are independent. However, the first node starts with both, active (pgpool2) and primary(postgres). It has a Floating IP. The rest of nodes have standby role (pgpool and postgres).

                  FLOATING IP
                 +-----------+     WATCHDOG
        +--------|  PGPOOL2  |--------+
        |        ------------- nic0   |
        |        |           |        |
        |        | POSTGRES  |        |
        |        | master    |        |
        |        +-----------+        |
        |          nic1|              |
  +-----------+        |        +-----------+
  |  PGPOOL2  |        |        |  PGPOOL2  |
  |-----------|        |        -------------
  |           |        |        |           |
  | POSTGRES  |        |        | POSTGRES  |
  | standby   |-----------------| stanby    |
  +-----------+   REPLICATION   +-----------+

Requirements

  • Debian 10
  • openssh-server
  • netaddr

Role Variables

Dependencies

  • Depends on other Ansible roles: false

Example Playbook

- hosts: all
  roles:
    - jobcespedes.pg_cluster

For verifying installation

- hosts: all
  tasks:
    - import_role:
        name: jobcespedes.pg_cluster
        tasks_from: verify

License

MIT

Author Information

Job Céspedes Ortiz: jobcespedes@gmail.com

About

Ansible role for a database cluster using Postgres (11), Pgpool2 (4.0) and Debian (10).

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published