Yes, now I can say the remap failed.
> /var/www/discourse# discourse remap staging.example.com forum.example.com
> Rewriting all occurences of staging.example.com to forum.example.com
> THIS TASK WILL REWRITE DATA, ARE YOU SURE (type YES)
> YES
> Error: ERROR: duplicate key value violates unique constraint "unique_post_links"
> DETAIL: Key (topic_id, post_id, url)=(8718, 57455, https://forum.example.com/t/exampletopic/4606/336) already exists.
> The remap has only been partially applied due to the error above. Please re-run the script again.
I re-ran it as instructed and got the same error, on the same (topic_id, post_id, url) key.
I can get to the rails console and run some SQL/ActiveRecord if you can tell me what to run. Or Data Explorer.