I was trying to restore my backup to a new server, and it showed some errors. The log is here: Ubuntu Pastebin The error maybe: PG::UniqueViolation: ERROR: could not create unique index "unique_index_categories_on_slug" DETAIL: Key (COALESCE(parent_category_id, '-1'::integer), slug)=(5, ) is du…

@Rasin , This should now be fixed as of: FIX: Add migrations to fix index on category slugs committed 02:02PM - 16 Oct 19 UTC (UTC) [image] danielwaterworth …

Failed to restore DB

Support Self-hosting

system (system) Closed November 16, 2019, 1:33am 11

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Cannot restore database: sql key is duplicated Self-hosting	2	568	August 30, 2022
Error restoring backup "key is duplicated" Self-hosting	8	1821	August 31, 2017
SQL Error during import Self-hosting	19	2327	May 3, 2015
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	8	1205	June 20, 2022
Error on restore: could not create unique index Self-hosting	1	1762	March 12, 2022

Failed to restore DB

Related topics