This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Populating postgis database from osm file with windows 10

0

Hello everyone. I have Windows 10 64bit installed on my pc. I want If i try to use

osm2pgsql.exe d:\osm\germany-filtered.osm -d osm -U postgres -P 5432 -S d:\osm\default.style --hstore --keep-coastlines

in the 32bit version it works for a while and then i get the error:

Reading in file: d:\osm\germany-filtered.osm
Processing: Node(52420k 213.1k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Node cache size is too small to fit all nodes. Please increase cache size
Error occurred, cleaning up

if i use 64bit and/or the -s switch, my Windows shows me a huge red banner that says that the app can't be executed on this pc and i should contact the software developer.

If i use the cygwin version i get the error:

  0 [main] osm2pgsql 4576 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer.  Please     report this problem to
the public mailing list cygwin@cygwin.com
osm2pgsql SVN version 0.83.0 (64bit id space)

Error: Connection to database failed: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Starting cmd.exe as an administrator delivers the same results.

How do i import my osm file into my postgrsql database for further usage?

Btw, i can't send the error to cygwin@cygwin.com because apparently my mail client sends as text/html and their server only accepts plain text -.-

asked 12 Nov '15, 20:40

EinFreierNick's gravatar image

EinFreierNick
1214512
accept rate: 50%

edited 12 Nov '15, 20:43

The cygwin error at least has occurred for other people previously:

https://www.google.co.uk/search?q=%22Couldn%27t+compute+FAST_CWD+pointer%22

(12 Nov '15, 20:55) SomeoneElse ♦
1

Yeah I run osm2pgsql fine and get this message every time. Nothing to worry about.

(13 Nov '15, 10:40) SK53 ♦

One Answer:

3

as it turned out the link to cygwin on the osm wiki page is outdated by 50 builds. The most current one works, with --host localhost.

I've updated the link on https://wiki.openstreetmap.org/wiki/Osm2pgsql#Cygwin so that others won't fall into that pit too.

answered 13 Nov '15, 08:18

EinFreierNick's gravatar image

EinFreierNick
1214512
accept rate: 50%

Source code available on GitHub .