[image] ERROR: cannot drop table users column email because other objects depend on it DETAIL: trigger users_email_readonly on table users depends on table users column email HINT: Use DROP … CASCADE to drop the dependent objects too.

So the docker install discourse/docs/INSTALL-cloud.md at main · discourse/discourse · GitHub install the LATEST… how to select a stable version?

Downgrading isn’t supported, you can’t roll back to beta or stable until they pass the current tests-passed. You can use the commit ID as per this topic, but it’s very unlikely a routine upgrade is the cause - Discourse isn’t prone to spontaneous combustion. Do you have sufficient free space on the server? Have you disabled all plugins and re-tried?

[image] Stephen: Downgrading isn’t supported OP is trying to restore a backup with a schema from 2017 so this is not what he is trying to do. Might this be related to the fact that delayed column drops are working differently nowadays?

Fair enough, I was going by the title, which said he was upgrading to beta9 +184.

Yes I was using v1.9 earlier and now I was planning to upgrade to v2.2. I switched from Bitnami to a dedicated Docker install. Somehow latest+latest was installed. So I got v2.3.0.beta9+184 where the backup import failed. So have to look up how to install a specific docker version

Yes! The solution basically is: to avoid this just run db:seed_fu before you backup or upgrade Postgres .

Restoring Discourse 1.9 backup onto v2.3.0.beta9 +184

Product Support

oluies (Orjan Lundberg) May 7, 2019, 6:57am 7

Might be similar to this Trouble upgrading from 1.9.0.beta11

Topic		Replies	Views
Trouble upgrading from 1.9.0.beta11 Self-hosting	2	761	December 29, 2018
Unable to restore from a backup Self-hosting	3	1075	August 30, 2017
Can't downgrade from beta to stable Product Support	7	1645	November 13, 2017
Reverting version after problematic update Self-hosting	14	1189	October 2, 2022
Upgrade fail unsupported Docker Version Self-hosting docker	9	648	May 18, 2025

Restoring Discourse 1.9 backup onto v2.3.0.beta9 +184

Related topics