OpenStreetMap 開放街圖
двух месяцев не прошло -- обновление через osm2pgsq заработало!
於 2024年一月31日 由 Zkir 以Russian (Русский)發表。Обновление локальной postgres базы OSM через osm2pgsq заработало, не прошло и двух месяцев.
osm2pgsql-replication update -v -d gis --max-diff-size 100 -- -G --hstore --tag-transform-script ~/src/openstreetmap-carto/openstreetmap-carto.lua -C 0 --flat-nodes ~/data/nodes.bin --number-processes 8 -S ~/src/openstreetmap-carto/openstreetmap-carto.style
Самое обидное, что не понятно, что конкретно изменилось. Если придется переустановить убунту, а похоже придется, то всё снова может отвалиться.
Так чтобы там не писали на switch2osm, свой тайловый сервер – это побольшей части магия.
討論
由 SomeoneElse 於 2024年01月31日 15時08分 發表的評論
:)
Pull requests welcome - or even an issue describing what did or did not work (including versions etc ).
I tend to test the “vanilla replication” version about once per new OS, but the pyosmium version more often since I use it myself.
由 Zkir 於 2024年02月 2日 23時12分 發表的評論
Andy, so you are the author of those switch2osm articles? ) It’s not that clear from the site.
Well, this is not about some particular small fixes. The whole process is too complex and way too complex for a newbie Linux user. As a such, I would prefer something like:
I guess it’s not possible (yet?) for many reasons :(
Also I’ve found out that the performance and even success of this whole thing heavily depends on the postgres configuration, and there are very little materials out there on this subject.
For example, after installation according to the manual, replication for small osm exports worked perfectly for small extracts, but on the whole planet it just froze completely. I’ve altered something in postgres conf, and it works now perfectly, but when I have to reinstall it, I will have to solve that puzzle again.
Also, I am still not able to get expected performance for the initial postgres import 14 hours against expected 7.5 and I am still not sure, whether the reason is different hardware or configuration of something. It’s not a big problem right now, but anyway.
由 SomeoneElse 於 2024年02月 3日 12時37分 發表的評論
With regard to “ease of setup”, the docker guide is probably the closest to a “create a server in one command” that we have. The “sudo apt install” at the top of “manual” instructions actually does almost all of the work for setting things up, but the “extras” such as replication (which there are at least 3 different ways to do, and at least three different sets of servers to do it with).
More information about postgres tuning for larger databases is definitely something that would be useful - earlier versions of the switch2osm guide and the precursors to it did have that but it’s not been something I’ve had a chance to test recently.