:joy::joy: I… version is v1.9.0.beta7 +341 [2017-08-29 15:27:03] ERROR: could not create unique index "index_topic_users_on_topic_id_and_user_id" [2017-08-29 15:27:03] DETAIL: Key (topic_id, user_id)=(59700, 11226) is duplicated. [2017-08-29 15:27:03] ERROR: current transaction is aborted, comm…

Error restoring backup "key is duplicated"

codinghorror (Jeff Atwood) August 30, 2017, 12:16am 5

That looks a lot like this one:

1 Like

Topic		Replies	Views
Cannot restore database: sql key is duplicated Self-hosting support	2	565	August 30, 2022
Restore fails - could not create unique index Self-hosting support	22	3917	July 6, 2020
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting support	8	1202	June 20, 2022
Error on restore: could not create unique index Self-hosting support	1	1758	March 12, 2022
Getting this error during restore: `could not create unique index` Self-hosting support	3	6889	November 20, 2023