PostgreSQL 18 update for self-hosters

I’ve just merged a fix for multisites and all DBs should now upgrade properly. You can revert your DB back to its pre-upgrade state and try again by doing the following:

  1. Confirm the old data still exists at /shared/postgres_data_old.
  2. Delete the botched upgrade data from /shared/postgres_data (if you have enough free disk space it might be an idea to rename for now instead of deleting it).
  3. Rename /shared/postgres_data_old back to /shared/postgres_data. You’ll also need to ensure the directory mode is 0700 or else Postgres will refuse to use it.
  4. Start the upgrade again by running ./launcher rebuild app.
3 Likes