Q: If you have an old DB from Discourse install, v2.0 > export - import > 2.9 - will it fail or is there a conversion process built into import to allow a successful importation?

Thank you for your replay but simply removing polls is not a solution to duplicate records. I assume somewhere early on the import from phpbb3 was incorrect and created those records. They are valid they just have duplicate UUID’s since original imported did not check for that. Anyway, the solution…

Ah thanks, that seems to work, except now failing to bootstrap on rebuild app. Seems to be a “discourse database already exists: type error” in there as well as ruby/gems error at the boot strap warning.

I’ve read through some of the errors. For context, this 2.2b4 build (PG10) is the original import setup and build used to import form another old school forum platform - this it has not had any updates or changes made since afaik. My impression is the solution may be to comment out some lines some…

You’d need to include your file for real help. If you see stuff like apt get Or something about modifying Gemfile, that would be stuff to remove. What I would probably do =given that the database upgrade worked) is rename your app.yml and run discourse-setup (assuming that your current file has…

Cool thanks for the pointers. I’ll try the rm app.yml and see what happens. When you say file do you mean errors in terminal or the app.yml or a different file? Extra info - I’m spinning up a droplet for learning and puzzling it out so I better understand how to maintain with the bonus of peace of…

Ok, tried all that - spun up new droplet, :white_check_mark: updates OS/Docker :white_check_mark: stopped container :white_check_mark: rm app.yml :white_check_mark: discourse-setup = upgraded PG10 :x: rebuild FAILED bootstrap (looks identical to yesterday’s error messages.) The errors that I…

[图片] agemo: I didn’t run this on/and trash a live forum In that case, just do a new installation, backup the old site, and restore it to the new site.

Ha ha, that was kind of my OP angling. If it’s that simple then all my problem are solved. See, my concern was I’d be exporting from PG10 into shiny new 2.9 which is PG13 is it not, and so will it suck in the database - my assumption would be no. Thus in backup and restore scenario, in this conte…

[图片] agemo: Is admin export/import sufficient without first upgrading the older DB Yes, it is, but you might need to fix a problem with your current DB before you can restore it on 2.9. [图片] agemo: duplicate key value violates unique constraint "index_poll_options_on_poll_id_and_digest" …

So it sounds like you have a corrupt index? (I didn’t notice but that’s what the last reply suggests). If that’s the car then you can look around for some examples. Mostly, you try to reindex and see which indexes won’t rebuild, then delete (or fix if you’re clever) the errant records.

将旧数据库导入到最新版本

支持安装

pfaffman (Jay Pfaffman) 2022 年5 月 19 日 16:49 2

A: PostgreSQL 13 更新

话题		回复	浏览量
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	17	2572	2020 年2 月 29 日
Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest Self-hosting	3	769	2023 年8 月 15 日
Error upgrading from 3.0.1 to 3.1.0 Self-hosting	14	778	2023 年3 月 28 日
Import failing with `could not create unique index` Self-hosting	5	2879	2020 年6 月 13 日
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	2	682	2020 年8 月 21 日

将旧数据库导入到最新版本

相关话题