Trying to restore a database from <meta name="generator" content="Discourse 3.3.0.beta1-dev - https://github.com/discourse/discourse version a4022f69f31af611bc0e21258b0ccb77dec38ba3"> to current. I copied the same app.yml and am restoring (new VM and trying to sidestep the pg upgrade, though m…

So I removed these: 20210108134117_add_pending_pms_table.rb 20210512090204_add_timestamps_to_automations.rb 20210530122323_move_triggers_to_fields.rb 20211119103353_adds_discourse_automation_user_global_notice.rb 20230412120414_add_prefers_encrypt_field_to_pending_pms.rb and probably should have r…

I think 3.3beta1 was before the plugin was included in core in April. Could this lead to any issues - for example, due to the plugin now being included in core while still also being installed separately via app.yml?

That’s a good idea, but that’s not it. I’m not including it again. I wonder if maybe I should have tried adding it (but I don’t see it in a quick look). My current idea is to drop all of the automations tables (they are empty) on the old site, make a new backup and trying restoring that.

Well, and then it failed because discourse_automations_automations was missing. :person_shrugging:

Yeah. You can close it. I’m unclear if it’ll ever happen to anyone else so that this may or may not be useful.

Relation "discourse_automation_automations" restoring from 3.3beta1 to 3.5beta7

Product Support Self-hosting

tobiaseigen (Tobias Eigen) September 17, 2025, 8:18pm 6

Can we close this topic? Or move it to Development or #installation:hosting if you want to keep it open ended?

Topic		Replies	Views
Discourse restore fails with relation already exists error Product Support backups	1	95	April 29, 2026
Rebuild fails on db:migrate "relation "form_templates" already exists" Self-hosting	9	528	October 25, 2023
Problem with restore Discourse from backup (3.4, quite large DB) Product Support	17	574	January 14, 2025
Database issues migrating form old version 20150822141540 Self-hosting	13	1270	September 22, 2022
Error when restoring from backup to new installation Self-hosting	1	691	February 18, 2021

Relation "discourse_automation_automations" restoring from 3.3beta1 to 3.5beta7

Related topics