[openstreetmap/openstreetmap-website] Add back users.nearby column as a dummy (#2543)

Carlos notifications at github.com
Sun Mar 15 19:52:47 UTC 2020


> My recommendation for the time being would be to introduce an additional column for the import via plain old Postgresql command line tools:
> 
> On psql, execute alter table users add column nearby integer default 50;
> Run osmosis osm api db import
> Again on psql execute: alter table users drop column nearby;
> 
> That would allow you to run osmosis as is, and avoids any additional trouble for production. Also, we don't need any Rails db migration. Trying to keep this simple.
> We could add this as a hint in https://github.com/openstreetmap/openstreetmap-website/blob/34dd2293db85e28b7e5df0889b0b778a685306bb/CONFIGURE.md#populating-the-database, mentioning that osmosis doesn't reflect the latest db schema changes.

I've done this and didn't figure out the error "Unable to insert user with id = -1 into the database." when import a geofabrik data into local osm website database.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/2543#issuecomment-599256163
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20200315/a0c43b71/attachment.htm>


More information about the rails-dev mailing list