Tutorial "Update PostgreSQL to the latest version"

[solderdot72]

Referring to this tutorial: https://dawarich.app/docs/tutorials/update-postgresql
I wonder if this is still required or maybe not...?
I see that the line image: postgres:14.2-alpine is to be replaced with a line image: postgres:17-alpine. However, in the current (v0.24.0) docker-compose.yml there is a line which now reads image: postgis/postgis:14-3.5-alpine but there is nothing like image: postgres:14.2-alpine.
Further, I installed Dwaraich via Portainer, so to me the question is, how to do the DB update in a Portainer environment. Can anybody share that knowledge?

[Freika]

@solderdot72 this guide will be updated soon

[Freika]

https://dawarich.app/docs/tutorials/update-postgresql

[solderdot72]

Thanks! Unfortunately not too helpful for me, living in a Portainer environment. Already trying to start the container in step 2 fails.
I now attempt doing a wholly new set-up, including deleting the database and importing 4.5M geopoints anew. The import will be quick, losing ~2M reverse geocoding information is the most expensive part here.
Just a note: Applying the changes from the final docker-compose.yml found in the tutorial does not work on Raspberry Pi. postgis/postgis:17-3.5-alpine does not work for ARM, I picked imresamu/postgis:17-3.5-alpine3.20 from the list you provide in https://dawarich.app/docs/tutorials/moving-to-postgis instead, and hope this is the correct one.
In general I find this transition not being suitable for the masses. There are way too many details to be considered and way too much knowledge anticipated for the average user attempting to make use of this otherwise marvellous project.

[noway42]

@solderdot72 I'm on the same boot here, Portainer environment, I will try to update probably later this afternoon. If I succeed, I will let you know how I did it.

@Freika Aren't the step 5 and 6 of your tutorial counterproductive? In step 5 you are renaming the new PG17 container to "dawarich_db", but in step 6 you replace dawarich_db in the docker-compose.yaml by "dawarich_db_pg_17". So if you'll start it up again you will end up with two PG17 containers or am I mistaken?