Full daily + WAL streaming
Base backup daily. WAL streaming to a separate host or S3 for point-in-time recovery. Standard playbook — use pgBackRest or Barman.
Advertisement
Session tier is critical
Session data is user-visible state. Losing it = broken user experience. RPO under 5 minutes is normal.
Advertisement
Event log is not critical
Events are audit history. Losing an hour of it is annoying, not catastrophic. Can save infrastructure cost with looser SLAs.