Menu

My nightly backup job had been green for months. I never restored it once.
🖼️

My nightly backup job had been green for months. I never restored it once.

DEV Community: postgres·Known Developer·about 10 hours ago
#dbRZfl16
#devtopostgresql#devto#dev#backup#backups
Reading 0:00
15s threshold

My nightly backup job had been green for months. I never restored it once.

Last week I looked at a cron job of mine that had printed "backup ok" every night for months, and I asked myself a plain question: when did I last load one of those files into a database? I could not remember a date. A green job tells you a file was written. It does not tell you the file works.

I built a small test and ran it end to end. I created a Postgres database, backed it up on a schedule, changed the live data afterwards, restored the backup into a separate database, and compared row counts. I used Levelrail, the self-hosted deploy platform I work on, built from the v1.0.1 release branch (commit d510e8488 ).…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.