A PostgreSQL upgrade
WebHare 6.0 and up will require the use of PostgreSQL version 17 or higher and will not ship any earlier version in its container images. You need to complete the database upgrade using WebHare 5.9.
To make the upgrade as painless as possible you should:
- Ensure you're running the most recent 5.9.x release. We expect tot maintain 5.9.x for longer than usual to backport bugfixes that help smooth the upgrade
- Ensure you have an up to date backup and that you restore procedure actually works
- Ensure you have enough free disk space. Check
du -sch /opt/whdata/postgresql/db
- you likely need at least twice that much to be free
You should test a dryrun upgrade first: wh db upgrade --dryrun
. This will also give you an idea of the expected downtime. Database upgrades generally take between 1 to 10 minutes, but this is completely dependent on
the size of your database and speed of your storage.
During migration a flag is set to prevent further writes to the database. The database is still available in readonly mode to keep as much webhosting alive as possible.
To do the actual upgrade, run wh db upgrade
.