How to transfering postgres data from pg14 to pg18?
❓Question☑️Ready
I changed from a ubuntu server to trueNAS and setup a new immich app and want to transfer the data to this new immich instance. I moved all the images to the correct library location on the nas and created a backup with:
Then i tried to import this backup in the new postgres 18 container with:
Only i got errors like
and
How do i properly move the database?
The previous postgres image was:
docker exec -t immich_postgres pg_dumpall -c -U postgres > immich_db_backup.sqlThen i tried to import this backup in the new postgres 18 container with:
cat immich_db_backup.sql | docker exec -i ix-immich-pgvecto-1 psql -U postgres -d immichOnly i got errors like
and
How do i properly move the database?
The previous postgres image was:
ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23