bcgov / wps

Wildfire Predictive Services to support decision making in prevention, preparedness, response and recovery
Apache License 2.0
39 stars 9 forks source link

Patroni: Enable pgbackrest backups and wal streaming #2751

Closed conbrad closed 8 months ago

conbrad commented 1 year ago

Describe the task We currently just have a pgdump based backup process which is slow a non-incremental. Enabling pgbackrest backups based on wal streaming allows us to:

  1. Have incremental backups
  2. Allow spinning up a crunchy cluster based off the pgbackrest repo

Acceptance Criteria

Additional context

conbrad commented 1 year ago

We could also try this tool without having to do this extra step: https://github.com/shayonj/pg_easy_replicate