Upgrade PostgreSQL to v16

[HerHde]

Heyo,

I've started a fresh Astuto with the recommended docker-compose.yml, but changed the PG image to a newer major:

  db:
-    image: postgres:14.5
+    image: postgres:16.0

I had no problems when I gave it a quick test run. Now my questions:

0. Do you intend to upgrade the referenced version to v16?
1. Is there an upgrade path, aka, does the DB need a manual migration, do you build it into Astuto or document it?

Thanks a lot!

[riggraz]

Hi HerHde, thanks for reaching out.

I'm happy to hear that Astuto works fine with postgres v16. If you feel like it, you can open a PR with the change so we could see if the test suite runs fine!

Is there an upgrade path, aka, does the DB need a manual migration, do you build it into Astuto or document it?

I'm not entirely sure what you mean here. Yes, the DB needs a manual migration each time its schema is changed: the migration is performed when you launch the container, i.e. when you run docker compose up. Hopefully that answers your question.