<p></p>
<blockquote>
<p>On my end, still trying to resolve:</p>
<blockquote>
<p>ERROR: duplicate key value violates unique constraint "users_display_name_idx"</p>
</blockquote>
</blockquote>
<p>Unfortunately, it seems that loading an extract into a Rails-schema database isn't on a happy path because it isn't something anyone does very frequently. On the downside, this means you're likely to encounter problems, but on the upside you're a pioneer! <g-emoji class="g-emoji" alias="wink" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f609.png">😉</g-emoji></p>
<p>I'm not aware of any better tool than Osmosis to do this, sorry (even taking into account the high likelihood of encountering further problems).</p>
<p>The first item of advice in the mailing list post you referenced is the one I would take if I wanted to load an extract: drop the table constraint, load the data, then repair the data so that the <code>display_name</code> fields are unique (e.g: <code>update users set display_name = 'user_' || id where display_name = </code> {whatever the duplicate value is}), then re-create the table constraint so that Rails is happy.</p>
<p>Hope that helps!</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/2449#issuecomment-646029571">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLPHPRC7QE463XYDQHLRXILTZANCNFSM4JVAZWAA">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AAK2OLMDP7SENC5WG342GN3RXILTZA5CNFSM4JVAZWAKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOE2A2CAY.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/2449#issuecomment-646029571",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2449#issuecomment-646029571",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>