PostgreSQL Database Error | Immich | Page 1

rigid burrow Sep 16, 2023, 1:29 AM

#

PostgreSQL Database directory appears to contain a database; Skipping initialization
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 15, which is not compatible with this version 16.0 (Debian 16.0-1.pgdg120+1).

brittle bear Sep 16, 2023, 1:31 AM

#

If you want to upgrade from postgres 15 to 16 you cannot simply use a new docker image. That will not work.

rigid burrow Sep 16, 2023, 1:31 AM

#

Is there another way? or shoudl i just keep it on version 15?

brittle bear Sep 16, 2023, 1:34 AM

#

Up to you. We actually are only using and testing with v14 I believe.

#

You can read the post red upgrade docs, but basically you just need to export the data via pgdumpall and then reimport it into the new database.

#

So like, dump the data, create a new container using a new folder for the database, then load the data, then bring up the rest of the immich containers.

#

Probably really similar to this:

https://immich.app/docs/administration/backup-and-restore

But you need to restore to v16

Backup and Restore | Immich

Database

#PostgreSQL Database Error