Playbook

pg_install              : # install postgres packages & extensions
  - pg_dbsu             : # setup os user sudo for postgres dbsu
    - pg_dbsu_create    : # exchange dbsu ssh keys
    - pg_dbsu_sudo      : # exchange dbsu ssh keys
    - pg_ssh            : # exchange dbsu ssh keys
  - pg_pkg              : # install postgres packages
    - pg_ext            : # install postgres extension packages
  - pg_link             : # link pgsql version bin to /usr/pgsql
  - pg_path             : # add pgsql bin to system path
  - pg_dir              : # create postgres directories and setup fhs
  - pg_bin              : # sync /pg/bin scripts
  - pg_alias            : # write pgsql/psql alias
  - pg_dummy            : # create dummy placeholder file

pg_bootstrap            : # bootstrap postgres cluster
  - pg_config           : # generate postgres config
    - pg_conf           : # generate patroni config
    - pg_key            : # generate pgsodium key
    - pg_pitr_conf      : # generate optional pitr config
  - pg_cert             : # issues certificates for postgres
    - pg_cert_private   : # check pg private key existence
    - pg_cert_issue     : # signing pg server certs
    - pg_cert_copy      : # copy key & certs to pg node
  - pg_launch           : # launch patroni primary & replicas  (patroni)
    - pg_watchdog       : # grant watchdog permission to postgres
    - pg_primary        : # launch patroni/postgres primary
    - pg_init           : # init pg cluster with roles/templates
    - pg_pass           : # write .pgpass file to pg home
    - pg_replica        : # launch patroni/postgres replicas
    - pg_hba            : # generate pg HBA rules
    - patroni_reload    : # reload patroni config
    - pg_patroni        : # pause or remove patroni if necessary

pg_provision            : # provision postgres business users & databases
 - pg_user              : # provision postgres business users
    - pg_user_config    : # render create user sql
    - pg_user_create    : # create user on postgres
 - pg_db                : # provision postgres business databases
    - pg_db_config      : # render create database sql
    - pg_db_create      : # create database on postgres

pg_backup               : # init postgres PITR backup
  - pgbackrest          : # setup pgbackrest for backup
    - pgbackrest_config : # generate pgbackrest config
    - pgbackrest_init   : # init pgbackrest repo
    - pgbackrest_backup : # make a initial backup after bootstrap

pg_access               : # init postgres service access, pool, dns, vip, svc
 - pgbouncer            : # deploy a pgbouncer sidecar with postgres
   - pgbouncer_dir      : # create pgbouncer directories
   - pgbouncer_config   : # generate pgbouncer config
     -  pgbouncer_hba   : # generate pgbouncer hba config
     -  pgbouncer_user  : # generate pgbouncer userlist
   -  pgbouncer_launch  : # launch pgbouncer pooling service
   -  pgbouncer_reload  : # reload pgbouncer config
 - pg_vip               : # bind vip to pgsql primary with vip-manager
   - pg_vip_config      : # generate config for vip-manager
   - pg_vip_launch      : # launch vip-manager to bind vip
 - pg_dns               : # register dns name to infra dnsmasq
   - pg_dns_ins         : # register pg instance name
   - pg_dns_cls         : # register pg cluster name
 - pg_service           : # expose pgsql service with haproxy
   - pg_service_config  : # generate local haproxy config for pg services
   - pg_service_reload  : # expose postgres services with haproxy

pg_monitor              : # setup pgsql monitor and register to infra
  - pg_exporter         : # config & launch pg_exporter
  - pgbouncer_exporter  : # config & launch pgbouncer_exporter
  - pgbackrest_exporter : # config & launch pgbackrest_exporter
  - register_prometheus : # register pg as prometheus monitor targets
  - register_grafana    : # register pg database as grafana datasource

pg_monitor               : # remove registration in prometheus, grafana, nginx
  - prometheus           : # remove monitor target from prometheus
  - grafana              : # remove datasource from grafana
  - pg_exporter          : # remove pg_exporter (postgres monitoring)
  - pgbouncer_exporter   : # remove pgbouncer_exporter (pgbouncer monitoring)
  - pgbackrest_exporter  : # remove pgbackrest_exporter (pgbackrest monitoring)

pg_access                : # remove pg service access
  - dns                  : # remove pg dns records
  - vip                  : # remove vip-manager
  - pg_service           : # remove pg service from haproxy
  - pgbouncer            : # remove pgbouncer connection middleware

postgres                 : # remove postgres instances
  - pg_replica           : # remove all replicas
  - pg_primary           : # remove primary instance
  - pg_meta              : # remove metadata from dcs

pg_backup                : # remove backup repo    (disable with `pg_rm_bkup=false`)
pg_data                  : # remove postgres data  (disable with `pg_rm_data=false`)
pg_pkg                   : # uninstall pg packages (disable with `pg_rm_pkg=false`)
 - pg_ext                : # uninstall postgres extensions alone

# remove pgsql cluster `pg-test`
./pgsql-rm.yml                          # remove all the postgres clusters (VERY DANGEROUS)
./pgsql-rm.yml -l pg-test               # remove the cluster `pg-test`
./pgsql-rm.yml -e pg_safeguard=false    # force disable safeguard, run this playbook anyway
./pgsql-rm.yml -e pg_rm_bkup=false      # do not purge pgbackrest backup repo by default (keep the backup)
./pgsql-rm.yml -e pg_rm_data=false      # do not purge postgres data by default (keep the data)
./pgsql-rm.yml -e pg_rm_pkg=false       # do not uninstall postgres packages by default (keep the packages)