[STARTED] ‘user1’ has started the restore! Marking restore as running… Making sure /workspace/discourse/tmp/restores/default/2026-04-29-211652 exists… Copying archive to tmp directory… Extracting dump file… Validating metadata… Current version: 20260420014648 Restored version: 20260420014648 Enablin…

hi @ziln :wave: welcome to discourse meta :slight_smile: [image] ziln: ERROR: type “ai_moderation_setting_type” already exists EXCEPTION: psql failed: ERROR: type “ai_moderation_setting_type” already exists i think it looks like your target instance isn’t clean or has data already, and yo…

I don’t know. That guy doesn’t sound like he knows much. :wink:

thanks for your input :slight_smile: Yes, I’ve tried droping and creating new db but I got the same error. I was only able to restore backup via SQL manually.

Backup Restoration Issue

Support Self-hosting

supermathie (Michael Brown) June 9, 2026, 11:26am 5

What’s the postgres role setup you have in your situation?

Topic		Replies	Views
Can't restore saved backup Self-hosting	3	1267	March 7, 2017
Error when restore DB backup Self-hosting	25	1895	August 23, 2018
Problem with restore Discourse from backup (3.4, quite large DB) Support	17	346	January 14, 2025
Trouble restoring from backup Support	10	1350	January 31, 2018
Restore has failed. when i backup and restore to a new discourse Support	13	1690	September 16, 2019

Backup Restoration Issue

Related topics