I moved my forum to a new domain but didn’t run the remap directly and now I get a conflict as there are some poste with the new and the old domain and running the remap will fail.
Error: ERROR: duplicate key value violates unique constraint "unique_post_links"
DETAIL: Key (topic_id, post_id, url)=(23737, 113202, https://MYDOMAIN/) already exists.
The remap has only been partially applied due to the error above. Please re-run the script again.
ist there a way to ignore this to remap at least everything else. Or can I manually remove that entry and from the database? I did something similar years ago but I can’t find how to get into pgsql.