[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	1263	March 7, 2017
Error when restore DB backup Self-hosting	25	1886	August 23, 2018
Problem with restore Discourse from backup (3.4, quite large DB) Support	17	338	January 14, 2025
Restore has failed. when i backup and restore to a new discourse Support	13	1682	September 16, 2019
Trouble restoring from backup Support	10	1344	January 31, 2018

Backup Restoration Issue

Related topics