Hello guys We have 2 working discourse forums and we would like to merge them. Is there a nice simple way to do this? thanks

Not that I know of. I guess you’d have to write an importer. Should be pretty easy to do since the db schema is the same :slight_smile:

@jmamazo did you do the merge the two discourse installations? Did you write an importer? I’m in the same situation…

[image] Discourse 2.1.0 beta 2 Release Notes megaphoneAnnouncements New features in 2.1.0 .beta2 Script to merge two Discourse sites We’ve been asked many times and now you can do it! The script will allow you to merge two Discourse forums into a single site by importing topics, posts, tags, groups and users. Not ready for production use yet. Plugin improvements Translator++, Solved and Assign plugins migrate to new DB.exec pattern because exec_sql is deprecated Staff Notes added a widget settings to show staff notes under avatar instead of in name Adverti… When the script will be ready to be used in production @neil will write a topic for that.

Hello @neil Now version 's Discourse is 2.1.0 beta 5. At this time, Everything is available for merge 2 Discourse forum? Do we have step by step to merger them? Thank you!

I have started a wiki post here: [image] Merge two Discourse sites into one packageMigrating to Discourse If you have two Discourse sites that you wish were one, this guide is for you. There’s a tool called discourse_merger that can take one Discourse site and merge it into another. Prereqs This is not an easy task, and should be treated like any other migration to Discourse. You will not be running discourse_merger on a live production site. You will perform the merge in another environment where you can review the output before moving the result to production. Copy vs Merge Almost everythin…

Dear @neil. I have started this process but with little success. It seems as though this discourse_merger is defaulting to using the user “discourse” to peer with the postgres instead of user “postgres”. I am getting inevitable peer authentication errors no matter the environment I work with. A more in-depth explanation of exactly what environment/docker you are working with (and how exactly you set this up from a start-point) to successfully get this working would be much appreciated. I’m currently using most recent stable beta btw. best, Walker

I think there are some missing options for username, password in the initialize method: script/bulk_import/discourse_merger.rb main def initialize db_password = ENV["DB_PASS"] || "import_password" local_db = ActiveRecord::Base.connection_db_config.configuration_hash @raw_connection = PG.connect( dbname: local_db[:database], If you’re still trying to get this work, try adding user: and password: options for both of those connections and see if that fixes it.

Got it, will try. And thank you!!! -Walker

I am going to try this and see. def initialize local_db = ActiveRecord::Base.connection_config @raw_connection = PG.connect(dbname: local_db[:database], host: 'localhost', user: 'postgres', port: local_db[:port]) @source_db_config = { dbname: ENV["DB_NAME"] || 'copyme', host: ENV["DB_HOST"] || 'localhost', user: ENV["DB_USER"] || 'postgres' }

It works with @raw_connection = PG.connect(dbname: local_db[:database], host: 'localhost', user: 'postgres', password: ' ', port: local_db[:port]) It’s a hard-bake but at least it goes. I had to do following to get password set: sudo -u postgres psql postgres \password postgres (enter the new password) \q Now onto new and interesting bugs like unique constraints (instead of copy-over)! best, Walker

Merging 2 discourse forums

Product Support

justin (Justin DiRose) January 8, 2021, 3:44pm 19

Most of this stuff has been answered now in the merger howto.

Topic		Replies	Views
Merging two Discourse forums Migration	30	5071	January 22, 2020
Merge two Discourse sites into one Migrating to Discourse how-to	5	9919	January 25, 2025
Problem for merge two forum Self-hosting	12	2293	May 12, 2022
Possible to merge two backups Product Support	2	140	August 30, 2024
Can we combine 2 separate discourse sites? Product Support	3	1108	January 20, 2023

Merging 2 discourse forums

Related topics