#!/usr/bin/env ansible-playbook
---
#==============================================================#
# File      :   pgsql-rm.yml
# Desc      :   remove pgsql from hosts
# Ctime     :   2020-05-12
# Mtime     :   2022-12-29
# Path      :   pgsql-rm.yml
# Author    :   Ruohang Feng (rh@vonng.com)
# License   :   AGPLv3
#==============================================================#
- name: PGSQL REMOVE
  become: yes
  hosts: all
  gather_facts: no
  ignore_errors: yes
  vars:
    pg_uninstall: false                # uninstall pg_packages? false by default
    #pg_safeguard: false               # prevent purging running postgres instance? false by default
    #pg_clean: true                    # remove postgres data? true by default
    #pgbackrest_clean: true            # remove pgbackrest backup stanza? true by default
  roles: [ { role: node_id }, { role: pg_remove } ]


#--------------------------------------------------------------#
# Usage
#--------------------------------------------------------------#
#  Remove pgsql cluster `pg-test`
#     pgsql-rm.yml -l pg-test       # remove cluster `pg-test`
#         -e pg_clean=true          # remove postgres data by default
#         -e pgbackrest_clean=true  # remove postgres backup by default (when removing primary)
#         -e pg_uninstall=false     # do not uninstall pg packages by default, explicit override required
#         -e pg_safeguard=false     # purge safeguard is not enabled by default, explicit override required
#
#  Remove a pgsql replica:
#     pgsql-rm.yml -l 10.10.10.13   # remove instance `10.10.10.13` from cluster `pg-test`
#     pgsql.yml -l pg-test --tags=pg_service  # refresh pg service after cluster shrink
#
#--------------------------------------------------------------#
# Utils
#--------------------------------------------------------------#
#
#  bin/pgsql-rm pg-meta             # remove pgsql cluster 'pg-meta'
#  bin/pgsql-rm pg-test 10.10.10.13 # remove pgsql instance '10.10.10.13' from 'pg-test'
#
#--------------------------------------------------------------#
# Tasks
#--------------------------------------------------------------#
# register       : remove registration in prometheus, grafana, nginx
#   - prometheus : remove monitor target from prometheus
#   - grafana    : remove datasource from grafana
# dns            : remove pg dns records
# vip            : remove pg vip manager
# pg_service     : remove service definition from haproxy
# pg_exporter    : remove pg_exporter & pgbouncer_exporter
# pgbouncer      : remove pgbouncer connection middleware
# postgres       : remove postgres instances
#   - pg_replica : remove all replicas
#   - pg_primary : remove primary instance
#   - dcs        : remove metadata from dcs
# pg_data        : remove postgres data (disable with `pg_clean=false`),
# pgbackrest     : remove postgres backup when removing primary (disable with `pgbackrest_clean=false`),
# pg_pkg         : remove postgres packages (enable with `pg_uninstall=true`)
#--------------------------------------------------------------#
...