Backup Restoration Issue

[Lilly]

hi @ziln welcome to discourse meta

@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 you’re getting an object collision.

assuming this is a standard install, try dropping and creating a clean new database, then doing the migration.

looks like pfaffman had a similar issue here:

@pfaffman

The solution was to drop, create, and migrate the database before doing the restore. I should have tried skipping the migrate step.