Hooks
Your DBA writes the pre-hook. Nobody shares an SSH key.
App owners attach drain, pause and resume scripts to their own servers. PatchManager runs them in order and stops if one fails.
# db-prod-01 · pre-hook psql -c "SELECT pg_wal_replay_pause();" systemctl stop pgbouncer # exit 0 → patching continues