How do you implement continuous WAL archiving with pgBackRest for near-zero RPO, and what monitoring is required?

Sample answer preview

Continuous WAL archiving ensures that every transaction is preserved in the backup repository almost immediately after it is committed, enabling near-zero RPO for point-in-time recovery.