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

Rasin (Rasin) October 16, 2019, 7:12am 3

How strange is this solution…FML
Will it be able to edit the sql file to make it normal?

I mean, if I there any way to ignore the duplicated key?

Topic		Replies	Views
Cannot restore database: sql key is duplicated Installation	2	543	August 30, 2022
Error restoring backup "key is duplicated" Installation	8	1784	August 31, 2017
SQL Error during import Installation	19	2281	May 3, 2015
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Installation	8	1154	June 20, 2022
Error on restore: could not create unique index Installation	1	1636	March 12, 2022

Failed to restore DB

Related topics