@tgxworld , I think this is in your wheelhouse. Trying to restore a backup from Discourse 2.1.0.beta5 - https://github.com/discourse/discourse version 8da2d8df3d5f7196f1c267b8a664597a725241ac or "Discourse 2.1.0.beta5 - https://github.com/discourse/discourse version bed34b52b51ab903bcb7854cc1efb2bf4…

Going to have to ship this into the support category, there could be some sort of bug here, but we need a proper repro that works consistently. Can you consistently make this fail?

Me too got this issue now. What I did: I did a backup with discourse 2.5.0.beta4. as root git clone https://github.com/discourse/discourse_docker.git /var/discourse cd /var/discourse cp /var/production-backup/var/discourse/containers/app.yml /var/discourse/containers/ mkdir -p /var/discourse/…

Can you restore it via the UI ?

No. > [2020-05-22 12:11:36] 'Patrick' has started the restore! > [2020-05-22 12:11:36] Marking restore as running... > [2020-05-22 12:11:36] Making sure /var/www/discourse/tmp/restores/default/2020-05-22-121136 exists... > [2020-05-22 12:11:36] Copying archive to tmp directory... > [2020-05-22 12:1…

Something is not right about your backup. Can you extract it on local and load it into a PG database? The gzip contains 2 files … 1 backups of PG and 1 uploads directory.

Thank you for help! I’ve created a new backup from the still fully functional old production server. Purged both docker and discourse from newer stage server. Re-installed both docker and discourse according official instructions. Then went with command line restoration instructions. The backup w…

[图片] adrelanos: Is it a legitimate approach to backup an outdated docker/postgres version and try to restore on an up to date docker/discourse installation? Yes, this is supported. [图片] adrelanos: ERROR: could not create unique index "index_incoming_referers_on_path_and_incoming_domain_…

I am getting the same error as the OP regarding “theme_fields” even on a brand new Discourse installation. E, [2020-06-04T16:32:44.492756 #2024] ERROR -- : PG::UndefinedTable: ERROR: relation "theme_fields" does not exist LINE 8: WHERE a.attrelid = '"theme_fields"'::regclass …

Are you running the latest version of Discourse? Is this an upgrade from an ancient version of Discourse?

This is a brand new fresh install of Discourse 2.4, no previous anything. I also tried upgrading to Postgres 12. Error still appears in my logs.

恢复问题：关系 "theme_fields" 不存在

支持安装

riking (Kane York) 2020 年5 月 25 日 17:08 8

是的，这是受支持的。

→ Corrupt indexes in PG12, how do I fix?

话题		回复	浏览量
Error when restore DB backup Self-hosting	26	1851	2018 年8 月 27 日
Database issues migrating form old version 20150822141540 Self-hosting	14	1038	2022 年10 月 22 日
Problem with restore Discourse from backup (3.4, quite large DB) Support	18	300	2025 年1 月 14 日
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4751	2020 年2 月 5 日
Restore failing- possible Data Explorer issue Self-hosting	21	2359	2019 年12 月 9 日

恢复问题：关系 "theme_fields" 不存在

相关话题