[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?

[图片] 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 .

将 Discourse 1.9 备份恢复到 v2.3.0.beta9 +184

产品支持

oluies (Orjan Lundberg) 2019 年5 月 7 日 06:57 7

Might be similar to this Trouble upgrading from 1.9.0.beta11

话题		回复	浏览量
Trouble upgrading from 1.9.0.beta11 Self-hosting	2	761	2018 年12 月 29 日
Unable to restore from a backup Self-hosting	3	1074	2017 年8 月 30 日
Can't downgrade from beta to stable Product Support	7	1641	2017 年11 月 13 日
Reverting version after problematic update Self-hosting	14	1185	2022 年10 月 2 日
Upgrade fail unsupported Docker Version Self-hosting docker	9	645	2025 年5 月 18 日

将 Discourse 1.9 备份恢复到 v2.3.0.beta9 +184

相关话题