Open nonprofittechy opened 11 months ago
Some additional thoughts:
pg_dump
[^1], and sends the gzipped dump to S3.pg_dump
as a scheduled job from the java size? idk. [^1]: Of the options mentioned in the postgres docs, the Write ahead log (WAL) is mostly for crash protection, and taking a file level archive says it should only be done when postgres is not running.
Although Postgres is transaction safe, this would still improve recoverability. We may want to keep at least a few days of dumps as well.