News for hackers. Stuff that matters.

A comment on Recovering a PostgreSQL database after a hard drive failure. Parent comment

Re:Recovering a PostgreSQL database after a hard drive failure by smbv on Friday December 31, 2021 @11:49AM (#29749767)
Working today to create a backup script and bind it to a systemd timer. Hope it all goes well.
[ Parent | on HN ]
Re:Recovering a PostgreSQL database after a hard drive failure by T3OU-736 on Saturday January 01, 2022 @12:28AM (#29755784)
(from bitter experience): Also consider periodically taking the backup and spinning it up on a separate host/VM.

And then codifying those steps into a script, so that if the time ever comes, restoring from backups is less of a fire drill.

[ Parent | on HN ]
Re:Recovering a PostgreSQL database after a hard drive failure by csdvrx on Friday December 31, 2021 @12:02PM (#29749912)
Add to your script the binary schema in case you ever need to use my tool it will make your life MUNCH simpler that reconstructing them by hand while fighting on multiple front to get your database back online...
[ Parent | on HN ]