[OSM-dev] osm2pgsql.exe

Bryce Nesbitt bryce2 at obviously.com
Sun May 18 09:25:17 BST 2008



Agentschlegel wrote:
> 
> I have had the same message that Stefan described
> and I have not found any solution yet.
> Is there any news on this issue?
> Best Regards
> Björn
> 

I can't get osm2pgsql to work on Debian, could this be the same issue?

I'm having trouble getting osm2pgsql  to connect to my local database. 
"psql" works fine, but "osm2pgsql" can't connect.  Any ideas?  I've set
pg_hba.conf to "trust", set a password, basically tried everything. 
osm2pgsql  will connect to a remote machine just fine.

$ psql -U bryce -h localhost gis
Password for user bryce:
Welcome to psql 8.2.7, the PostgreSQL interactive terminal.
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
gis=> \q


$ osm2pgsql -U bryce -H localhost -m -d gis map_sf.osm
osm2pgsql SVN version 0.52-20080413 $Rev: 7141 $

Password:
Connection to database failed: could not connect to server: Connection
refused
       Is the server running on host "localhost" and accepting
       TCP/IP connections on port 5432?


$ osm2pgsql -U bryce -m -d gis map_sf.osm
osm2pgsql SVN version 0.52-20080413 $Rev: 7141 $

Password:
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
"/var/run/postgresql/.s.PGSQL.5432"?


# osm2pgsql -m -d gis map_sf.osm
osm2pgsql SVN version 0.52-20080413 $Rev: 7141 $

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
"/var/run/postgresql/.s.PGSQL.5432"?


$ ls -la /var/run/postgresql/
total 16
drwxrwsr-x  2 postgres postgres 4096 2008-05-18 01:08 .
drwxr-xr-x 15 root     root     4096 2008-05-17 22:26 ..
-rw-------  1 postgres postgres    6 2008-05-18 01:08 8.2-main.pid
srwxrwxrwx  1 postgres postgres    0 2008-05-18 01:08 .s.PGSQL.5433
-rw-------  1 postgres postgres   35 2008-05-18 01:08 .s.PGSQL.5433.lock

-- 
View this message in context: http://www.nabble.com/Re%3A-osm2pgsql.exe-tp15555742p17300281.html
Sent from the OpenStreetMap - Dev mailing list archive at Nabble.com.





More information about the dev mailing list