I’m stuck trying to upgrade a docker Discourse instance. I get the following error when I attempt to rebuild, bootstrap or in any other way setup the container:
I, [2020-11-18T15:23:37.357104 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake plugin:pull_compatible_all' I, [2020-11-18T15:23:40.298932 #1] INFO -- : discourse-slack-official is already at latest compatible version docker_manager is already at latest compatible version I, [2020-11-18T15:23:40.299193 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' rake aborted! StandardError: An error has occurred, all later migrations canceled: PG::SyntaxError: ERROR: syntax error at or near "NOT" LINE 2: ADD COLUMN IF NOT EXISTS image_upload_id bigint ^
From investigating, it seems like postgresql 12 is required for the latest discourse but this currently isn’t packaged in the official docker image.
It looks like there’s a development branch in the repo for building the container with postgres12 but no outstanding PRs or anything…
How can I go about fixing/updating my discourse installation? The update path is incorrect and now I’m fighting to get the forums back up asap!