Point-in-time restore of a Patroni cluster with pgBackRest (tested)Originally published at https://twinhullhq.com/articles/point-in-time-restore-patroni-pgbackrest.html Someone ran DROP TABLE on production. You have pgBackRest backups and a WAL archive, so the data cOct 10 · 6 min readtwinhull.hashnode.dev
Patroni and HAProxy: which health check to use (/primary, /replica, /leader and the rest)Originally published at https://twinhullhq.com/articles/patroni-haproxy-health-check-endpoints.html HAProxy cannot see which PostgreSQL node is the primary. It asks Patroni, over HTTP, and Patroni ans1XOct 6 · 5 min readtwinhull.hashnode.dev
