Unable to restore backup data, unique index is duplicated

[codinghorror (Jeff Atwood)]

This is your actual error

could not create unique index "index_site_settings_on_name"
DETAIL:  Key (name)=(has_login_hint) is duplicated.