Postgres upgrade instructions missing

[nidico]

Postgres has recently (in 9469c23) been upgraded from 9.6 to 13.4 in the default/example docker-compose.yml file.

Users just upgrading the container repo will face the following error:

The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 13.4.

Database upgrade instructions should be added to the docker upgrade notes.

[SISheogorath]

I wrote a first draft for a guide, maybe needs some testing and validation: https://demo.hedgedoc.org/WDjvPVweTBWqVyUEg8A6Kw#

Feel free to try it and give some feedback :)

[nidico]

Thanks!

I've tried it and it works for me when changing exec -t to exec -T in step 11.

[GrSto]

Thanks a lot for this guide!

I followed these steps, but unfortunately, all our pads were empty after step 11. I'm not sure what exactly went wrong. There were no error messages logged to the console; in fact, step 11 produced no output at all.

I tried the following command from the official documentation instead:

cat backup-$(date +%Y-%m-%d).sql | docker exec -i $(docker-compose ps -q database) psql -U hedgedoc

This produced many lines of SQL console messages (like ALTER TABLE, COPY, ...). Now everything seems to work again.