TIL PG synchronous replication write durability order is determined by synchronous_commit settings:
remote_apply > on > remote_write
remote_apply: replica: fsync WAL + applied to DB
on: replica: fsync WAL only
remote_write: ack by replica - not written to disk
#postgresql
#til in Postgres >= 10 - "table pg_hba_file_file_rules" gets the contents of pg_hba.conf - BUT its what is in the file, not necessarily what is actually loaded in your pg process. Its documented as such https://t.co/UhojQQefmx - an easy one to miss
#postgresql
@geerlingguy Minor issue but I believe the format of requirements.yml has changed since the 2nd edition of Ansible for Devops was published - pg 143,144. Something for the errata maybe