Re:PostgreSQL upgrades are hard
by forinti on Saturday June 25, 2022 @08:49AM
(#31874871)
I've used dumps as backups and never experienced this issue, although they would stop prematurely from time to time. The solution was just to check the string at the end and repeat the dump if it wasn't there.
[ Parent
| on HN ]
Re:PostgreSQL upgrades are hard
by 411111111111111 on Saturday June 25, 2022 @09:14AM
(#31875041)
Considering that -Fc is a binary format, how would i check a string at the end of it?
If you do an SQL dump, it will end with "-- PostgreSQL database dump complete".
If you use -Fc, you can make an SQL file from the dump using pg_restore like this:
pg_restore -f db.sql db.dmp
Or straight to stdout like this: pg_restore -f - db.dmp | grep "database dump complete"
Although I guess if it's corrupted pg_restore won't work.It is really fast, but might not be practical if your database is too big.
Re:PostgreSQL upgrades are hard
by 411111111111111 on Saturday June 25, 2022 @10:28AM
(#31875566)
My issue was indeed the mishmash of versions, as the restore succeeded with the mentioned steps (installing old version, restoring, upgrading).
nonetheless, interesting way to validate a backup, though it would probably take too long on most dumps