Restore problem: "Could no create unique index"

support
1

Hi. I am trying to restore the forum using the downloaded backup, but getting the following error:

ERROR: could not create unique index "index_users_on_username_lower"DETAIL: Key (username_lower)=(alex) is duplicated.

After looking into the usernames manually, I can see that there are two users with a name Alex - one with uppercase while another one with lowercase. Looks like it is perceived as a duplicate record. Any suggestion on how to resolve the issue would be highly appreciated.

2 Likes
2

You could try renaming one to Alex2 then try and change it back after restoring, otherwise a developer would have to chime in as to why this is happening

1 Like
3

Can you fix it on the place it came from and get a new backup? That’s easiest. Next would be to edit the SQL with a different username.