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, 12:46pm 6

Thank you very much on this extracting thing!

Could you please help me with the duplicated key error? Or is there a way I can fix this sql on psql?

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

Failed to restore DB

Related topics