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: https://github.com/discourse/discourse/commit/7ba914f1e10d90b1e4d25b0ab2427c94df456eae Thank you for bringing this to our attention and I’m sorry for any inconvenience. Let us know if you have any other problems.

Failed to restore DB

Installation

Roman_Rizzi (Roman Rizzi) October 16, 2019, 12:19pm 5

Take a look at:

2 Likes

Topic		Replies	Views
Cannot restore database: sql key is duplicated Installation	2	531	August 30, 2022
Error importing backup: "could not create unique index" Installation	7	944	November 1, 2021
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Installation	8	1056	June 20, 2022
SQL Error during import Installation	19	2262	May 3, 2015
Restore fails: could not create unique index Installation	10	1134	February 13, 2022

Failed to restore DB

Related topics