Issue with Postgres bump from 15 to 16 if image: postgres in compose about linkwarden HOT 7 OPEN

As the docker-compose is using latest tag of postgres and the postgres 16 is now the latest, postgres container will fail to run with the following error:

linkwarden-postgres-1  | 2023-09-19 13:34:48.347 UTC [1] FATAL:  database files are incompatible with server
linkwarden-postgres-1  | 2023-09-19 13:34:48.347 UTC [1] 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).

This is viable workaround:

# docker-compose.yml

image: postgres:15

from linkwarden.

As the docker-compose is using latest tag of postgres and the postgres 16 is now the latest, postgres container will fail to run with the following error:

linkwarden-postgres-1  | 2023-09-19 13:34:48.347 UTC [1] FATAL:  database files are incompatible with server
linkwarden-postgres-1  | 2023-09-19 13:34:48.347 UTC [1] 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).

This is viable workaround:

# docker-compose.yml

image: postgres:15

Applied the same change to fix:

2023-11-22 15:28:59.169 UTC [1] FATAL:  database files are incompatible with server
2023-11-22 15:28:59.169 UTC [1] DETAIL:  The data directory was initialized by PostgreSQL version 15, which is not compatible with this version 16.1 (Debian 16.1-1.pgdg120+1).

from linkwarden.

Hello @stanthewizzard,
AFAIK there shouldn't be any restrictions on which postgres version you are using.

from linkwarden.

after update ... doesn't work anymore in my case
I can revert to postfres and give it a try

from linkwarden.

I'm already with this workaround
thanks :)

from linkwarden.

found it

In docker-compose.yml you could change

db-data:/var/lib/postgresql/data:rw
to this

db-data:/var/lib/postgresql@16/data:rw
Delete image and run

docker-compose up -d
one more time

from linkwarden.

AFAIK, to upgrade a major postgres version, we will have to do it manually, either by dumping our database and reimporting it or using pg_upgrade. https://www.postgresql.org/docs/current/upgrading.html

from linkwarden.