News for hackers. Stuff that matters.
Re:PostgreSQL upgrades are hard by forinti on Saturday June 25, 2022 @09:57AM (#31875339)
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