How to Migrate Postgres on Unraid
I recently needed to upgrade my PostgreSql instance from 13 to 14 in order to use the latest version of Immich and Davinci Resolve on the same server.
I didn't find it very intuitive and thought I'd record the process so that maybe it would help someone else out there. This isn't strictly limited to Unraid but the file paths and mappings are Unraid specific. You can likely adapt it to however you're hosting Docker with the same commands but be aware of where you are saving it.
Commands:
You'll need to replace components with your Postgres Username, IP address, port, and database name.
pg_dump -U DBUSERNAME -h IPADDRESS -p PORT -Fc -f /var/lib/postgresql/data/immich.dump DBNAME
pg_restore -U DBUSERNAME -h IPADDRESS -p PORT -d DBNAME /var/lib/postgresql/data/immich.dump