Documented how to do PostgreSQL Major version upgrades with Docker

[ajfriesen]

Long time umami user since 2021.
I am running a Docker compose setup and still was running on PostgreSQL 12 and decided to do the major version upgrades to PostgreSQL 15.

PostgreSQL refuses to do major version upgrades when bumping the container version. You need to dump and import your data.

Everything worked fine except from version 13 to 14 umami and postgres gave me this error:

umami          | yarn run v1.22.19
umami          | $ npm-run-all check-db update-tracker start-server
umami          | $ node scripts/check-db.js
umami          | ✓ DATABASE_URL is defined.
umami-db-14    | 2023-10-03 07:58:53.769 UTC [135] FATAL:  password authentication failed for user "umami"
umami-db-14    | 2023-10-03 07:58:53.769 UTC [135] DETAIL:  User "umami" does not have a valid SCRAM secret.
umami-db-14    | 	Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
umami          | ✗ Unable to connect to the database.
umami          | error Command failed with exit code 1.
umami          | info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
umami          | ERROR: "check-db" exited with 1.
umami          | error Command failed with exit code 1.
umami          | info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

I have documented my upgrade process and the solutions for the problem with the password hash SCRAM problem here:
https://www.ajfriesen.com/postgresql-upgrades-docker/

Hope that saves someone time.