search

osm2pgsql-dev / osm2pgsql

OpenStreetMap data to PostgreSQL converter
https://osm2pgsql.org
GNU General Public License v2.0
1.51k stars 474 forks source link

windows version, please #472

Closed luzhskij closed 9 years ago

luzhskij commented 9 years ago

Hello! But could not someone put the latest version of windows? The latter of which can be found online - 0.85-cpp-win-cmake (64bit id space).

alex85k commented 9 years ago

Here is the development build of current 0.88 branch: https://ci.appveyor.com/project/alex85k/osm2pgsql-cmake/build/artifacts (about 2 weeks ago)

The current automatic builds will be here, when I'll fix them: https://ci.appveyor.com/project/alex85k/osm2pgsql/build/artifacts

alex85k commented 9 years ago

Automatic build 0.89-dev is ready: https://ci.appveyor.com/project/alex85k/osm2pgsql/build/artifacts

luzhskij commented 9 years ago

Thank you so much!

alex85k commented 9 years ago

Be careful, no one is sure if it works correctly on big files :)

luzhskij commented 9 years ago

But what use to import Planet PBF File to pgsql?

alex85k commented 9 years ago

It may work. Huge restructuring was done after 0.85 and no one tried that on big data.

It is better to start with one big country extract and when it works correctly (render etc.), tune the options to achive better speed and then give the a planet file to the same script (hope you have 32-64 Gb RAM + ~40Gb free hd for node cache).

Windows support is still in development, multi-threading does not fully work etc.

Please let us know if it will pass correctly or if any problems arise :)

pnorman commented 9 years ago

I think this is a duplicate of #17. At this point, I'd recommend building Windows from the branch in #460 rather than master.

For large files, it is not generally recommended that you use Windows for running a large database. This doesn't mean you couldn't use osm2pgsql on Windows and connect it to a large database server, but no one I know does this, since you still need a machine running Linux, BSD, or OS X.

achapkowski commented 9 years ago

@pnorman - can you explain your statement a bit more? Are there recommended design docs out there for a windows system or windows/linux hybrid?

Thanks

pnorman commented 9 years ago

@pnorman - can you explain your statement a bit more? Are there recommended design docs out there for a windows system or windows/linux hybrid?

PostgreSQL 9.0 High Performance states "In practice, systems doing the sort of large queries that most benefit from this are not commonly practical on Windows anyway, due to its limitations in shared memory and connection capacity". You can find other statements about the limitations of Windows for large databases, and osm2pgsql whole planet imports are generally large. See also https://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows

If you are not operating the database server yourself, it's then not an issue, and you might want to then run osm2pgsql on a different machine, which might end up being Windows. This is generally unlikely.