Chat, I accidentally pg_dumpped (sql) a pg14 database (friggin immich stuck at 14) with pg_dump from pg16. That worked fine (why oh why did that not cause any errors!), but obviously now that I suddenly need said backup, a pg14 server is super unhappy with the backup and just screams syntax errors at me. How on earth can I restore this frankenbackup into anything that can then be downgraded back to pg14 so that Immich will be happy with it? I don’t think major version downgrades are even a thing?
My best idea is spinning up a throwaway pg16, restore there, dump it with pg14 (would that even work?) and then restore to pg14 proper. Just too tired by this point to attempt this safely without causing even more damage so better postpone it to tomorrow.
Asking lazyweb because search engines are toast and the internet is dying, or perhaps no one has ever failed in this stupid a way. Yes, I forgot that obviously my system postgres is new while Immich expects ancient. Fuck my life.