[OSM-dev] osm2pgsql.exe

[Stefan Baebler]

Artem Pavlenko wrote:
> Hello windows users,
>
> osm2pgsql.exe has arrived : http://artem.dev.openstreetmap.org/files/ 
> osm2pgsql_latest.exe.zip
>   
Tnx!

But where did i go wrong?
pgsql 8.2 + posgis
database named gis with postgis extensions, owned by new pqsql user 
"Stefan" (matches my windows username) with maximum permissions
access: all databases, all users from localhost, "trust" authentication 
method (=no passwords)
disabled windows firewall (although pgadmin can connect even with 
firewall enabled, and also telnet to port 5432 looks successful)
yet it still claims a password should be provided somewhere...

$>osm2pgsql_latest.exe -v data\slovenia-071024.osm.bz2
osm2pgsql win32

Using projection SRS 3395 (WGS84 Mercator)
Setting up table: planet_osm_point
Connection to database failed: fe_sendauth: no password supplied

any idea?

tnx,
Stefan

CREATE ROLE "Stefan" LOGIN
  SUPERUSER INHERIT CREATEDB CREATEROLE;
UPDATE pg_authid SET rolcatupdate=true WHERE OID=34261::oid;

CREATE DATABASE gis
  WITH OWNER = "Stefan"
       ENCODING = 'UTF8'
       TABLESPACE = pg_default;
GRANT ALL ON DATABASE gis TO public;
GRANT ALL ON DATABASE gis TO "Stefan";
COMMENT ON DATABASE gis IS 'OSM';