Use of a more recent version of Postgresql ?

[EnercoopJNE]

Hello !
In Teedy's documentation the Postgresql version provided by the Docker image is still 13, and it's reaching EOL by the end of the year.
I guess that it's not really a security concern when using the container, but it is for us because to resolve a weird bug (our DB was continuously filling if I recall correctly) we had to use a PG instance installed directly on the host server. I can't find the trace of that in any issue here that a colleague might have written but it's been several years and it's running smoothly.

So we need to upgrade PG, and if anyone reading this has an experience of Teedy running with a more recent PG version than 13, Docker or not, that would be really helpful.
If I rely on #679 it should work with PG 14, but not sure.

Anyway after a little while I'll do the upgrade to 15 in a test environnement, and I'll keep this issue updated, for the record.

[jendib]

Maybe upgrading the driver would be a good idea, if you feel like creating PR

[EnercoopJNE]

Well I could but we're not using the Docker container anymore for the database, so I could only test on a fresh install.

[jendib]

The driver version is defined in the pom.xml, it's unrelated to how the app is deployed. It's currently on version 42.6.0

[EnercoopJNE]

Ah OK I didn't make the connection with JDBC, my bad. I'm guessing it should work with 42.6.0 but that could be the opportunity to upgrade that as well. I'll do a PR if I change pom.xml, and if it works.

[vmario89]

i've put all the docs back to https://wiki.stadtfabrikanten.org/books/inventar-und-handbucher, which were lost since our server hack in 11/2023. We are running pgsql 16 and still works fine. No issue with newer database format