[Tile-serving] [osm2pgsql] osm2pgsql not adding the ways to the database (#165)

baditaflorin notifications at github.com
Thu Jul 3 18:20:30 UTC 2014


how do i do this ?

With the --slim argument is seems to do more

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\florin>cd..

C:\Users>cd..

C:\>dir
 Volume in drive C has no label.
 Volume Serial Number is A612-A224

 Directory of C:\

07/03/2014  08:18 PM               111 .dir
03/18/2014  04:13 PM    <DIR>          25b8ef4e2c10f9e9e3746431868f
04/24/2014  01:01 AM    <DIR>          cygwin64
07/03/2014  05:20 PM             6,025 default.style
06/19/2014  01:13 PM             6,549 IFRToolLog.txt
03/16/2014  03:55 AM    <DIR>          Intel
07/03/2014  03:39 AM       380,258,548 leisure.osm
07/03/2014  05:28 PM    <DIR>          osm2pgsql
07/14/2009  06:20 AM    <DIR>          PerfLogs
03/16/2014  04:29 AM    <DIR>          PORTABLE APPS
04/05/2014  02:37 AM    <DIR>          Prey
07/03/2014  05:33 PM    <DIR>          Program Files
07/03/2014  05:50 PM    <DIR>          Program Files (x86)
06/23/2014  09:30 PM    <DIR>          Python27
06/28/2014  01:07 AM    <DIR>          Qt
06/25/2014  12:11 AM    <DIR>          R
06/25/2014  12:11 AM    <DIR>          R64
06/25/2014  12:11 AM    <DIR>          Rtools
05/13/2014  02:14 PM    <DIR>          TEMP
03/16/2014  08:16 AM    <DIR>          Users
04/01/2014  03:44 PM    <DIR>          Windows
06/16/2014  01:53 AM    <DIR>          WORDS
               4 File(s)    380,271,233 bytes
              18 Dir(s)   5,967,769,600 bytes free

C:\>cd osm2pgsql

C:\osm2pgsql>dir
 Volume in drive C has no label.
 Volume Serial Number is A612-A224

 Directory of C:\osm2pgsql

07/03/2014  05:28 PM    <DIR>          .
07/03/2014  05:28 PM    <DIR>          ..
02/09/2013  12:02 AM               466 readme.txt
02/09/2013  12:04 AM    <DIR>          Win32
02/09/2013  12:03 AM    <DIR>          x64
               1 File(s)            466 bytes
               4 Dir(s)   5,967,769,600 bytes free

C:\osm2pgsql>cd win32

C:\osm2pgsql\Win32>dir
 Volume in drive C has no label.
 Volume Serial Number is A612-A224

 Directory of C:\osm2pgsql\Win32

02/09/2013  12:04 AM    <DIR>          .
02/09/2013  12:04 AM    <DIR>          ..
11/03/2012  12:16 PM           962,048 geos.dll
11/03/2012  12:15 PM           641,024 geos_c.dll
02/07/2013  12:07 AM            56,320 libbz2.dll
02/07/2013  12:07 AM         1,156,608 libeay32.dll
02/07/2013  12:07 AM           163,292 libintl.dll
02/07/2013  12:07 AM         4,033,440 libmmd.dll
02/07/2013  12:07 AM           137,216 libpq.dll
11/03/2012  05:09 PM         1,033,728 libxml2.dll
02/07/2013  12:07 AM           421,200 msvcp100.dll
02/07/2013  12:07 AM           773,968 msvcr100.dll
02/07/2013  12:17 AM           553,472 osm2pgsql.exe
02/07/2013  12:17 AM           547,328 osm2pgsql_32bitId.exe
11/03/2012  05:17 PM           265,728 proj.dll
02/07/2013  12:07 AM           265,216 ssleay32.dll
11/04/2012  12:04 PM            66,560 zlib.dll
              15 File(s)     11,077,148 bytes
               2 Dir(s)   5,967,769,600 bytes free

C:\osm2pgsql\Win32>cd..

C:\osm2pgsql>cd x64

C:\osm2pgsql\x64>dir
 Volume in drive C has no label.
 Volume Serial Number is A612-A224

 Directory of C:\osm2pgsql\x64

02/09/2013  12:03 AM    <DIR>          .
02/09/2013  12:03 AM    <DIR>          ..
11/03/2012  12:15 PM         1,176,064 geos.dll
11/03/2012  12:14 PM           816,128 geos_c.dll
02/07/2013  12:09 AM            64,000 libbz2.dll
02/07/2013  12:07 AM         1,577,472 libeay32.dll
02/07/2013  12:07 AM           240,862 libintl-8.dll
02/07/2013  12:07 AM         3,256,224 libmmd.dll
02/07/2013  12:07 AM           176,128 libpq.dll
11/03/2012  05:14 PM         1,333,248 libxml2.dll
02/07/2013  12:07 AM           608,080 msvcp100.dll
02/07/2013  12:07 AM           829,264 msvcr100.dll
02/07/2013  12:17 AM           603,136 osm2pgsql.exe
02/07/2013  12:17 AM           602,112 osm2pgsql_32bitId.exe
11/03/2012  05:19 PM           369,152 proj.dll
02/07/2013  12:07 AM           338,944 ssleay32.dll
11/04/2012  12:05 PM            77,312 zlib.dll
              15 File(s)     12,068,126 bytes
               2 Dir(s)   5,967,769,600 bytes free

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm -U postgres -H localhost
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Usage error. For further information see:
        osm2pgsql.exe -h|--help

C:\osm2pgsql\x64>-S C:\default.style C:\leisure.osm
'-S' is not recognized as an internal or external command,
operable program or batch file.

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm -U postgres -H localhost -S
C:\defau
lt.style C:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE:  table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE:  table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for sparse node cache
Node-cache: cache=800MB, maxblocks=102401*zd, allocation method=8192
Mid: pgsql, scale=100 cache=800
Setting up table: planet_osm_nodes
NOTICE:  table "planet_osm_nodes" does not exist, skipping
Setting up table: planet_osm_ways
NOTICE:  table "planet_osm_ways" does not exist, skipping
Setting up table: planet_osm_rels
NOTICE:  table "planet_osm_rels" does not exist, skipping

Reading in file: C:\leisure.osm
Processing: Node(50k 50.8k/s) Way(660k 16.93k/s) Relation(0 0.00/s)  parse
time:
 40s

Node stats: total(50773), max(2944613734) in 1s
Way stats: total(660251), max(291008873) in 39s
Relation stats: total(0), max(0) in 0s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending ways...
        660072 ways are pending

Using 1 helper-processes
Helper process 0 out of 1 initialised
Process 0 finished processing 660072 ways in 179 sec

All child processes exited

660072 Pending ways took 179s at a rate of 3687.55/s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending relations...
        0 relations are pending

Using 1 helper-processes
Process 0 finished processing 0 relations in 0 sec

All child processes exited

node cache: stored: 50773(100.00%), storage efficiency: 50.00% (dense
blocks: 0,
 sparse nodes: 50773), hit rate: 0.01%
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes in 0s
Stopping table: planet_osm_ways
Building index on table: planet_osm_ways (fastupdate=off)
Stopped table: planet_osm_ways in 137s
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels (fastupdate=off)
Stopped table: planet_osm_rels in 0s
Sorting data and creating indexes for planet_osm_point
Analyzing planet_osm_point finished
Copying planet_osm_point to cluster by geometry finished
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_point created  in 2s
Completed planet_osm_point
Sorting data and creating indexes for planet_osm_line
Analyzing planet_osm_line finished
Copying planet_osm_line to cluster by geometry finished
Creating indexes on  planet_osm_line finished
All indexes on  planet_osm_line created  in 0s
Completed planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
Analyzing planet_osm_polygon finished
Copying planet_osm_polygon to cluster by geometry finished
Creating indexes on  planet_osm_polygon finished
All indexes on  planet_osm_polygon created  in 1s
Completed planet_osm_polygon
Sorting data and creating indexes for planet_osm_roads
Analyzing planet_osm_roads finished
Copying planet_osm_roads to cluster by geometry finished
Creating indexes on  planet_osm_roads finished
All indexes on  planet_osm_roads created  in 0s
Completed planet_osm_roads

Osm2pgsql took 366s overall

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 -U postgres -H localhost -S
--numbe
r-porcesses 5 C:\default.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Error: Connection to database failed: fe_sendauth: no password supplied


C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 -W -U postgres -H localhost -S
--nu
mber-porcesses 5 C:\default.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
osm2pgsql: illegal option -- W
Usage error. For further information see:
        osm2pgsql.exe -h|--help

C:\osm2pgsql\x64>
C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 --password -U postgres -H
localhost
 -S --number-porcesses 5 C:\default.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Error: Connection to database failed: fe_sendauth: no password supplied


C:\osm2pgsql\x64>SET pgpassword=123456

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 -U postgres -H localhost -S
--numbe
r-porcesses 5 C:\default.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Using projection SRS 900913 (Spherical Mercator)
Couldn't open style file '--number-porcesses': No such file or directory
Error occurred, cleaning up

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 -U postgres -H localhost -S
--numbe
r-processes 5 C:\default.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Using projection SRS 900913 (Spherical Mercator)
Couldn't open style file '--number-processes': No such file or directory
Error occurred, cleaning up

C:\osm2pgsql\x64>osm2pgsql --slim -c -d osm2 -U postgres -H localhost -S
C:\defa
ult.style F:\leisure.osm
osm2pgsql SVN version af61cae663 (64bit id space)

release notes: 'Windows version built by Dominik Perpeet (
http://www.customdebug
.com/osm2pgsql/index.html)'
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE:  table "planet_osm_line" does not exist, skipping
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE:  table "planet_osm_polygon" does not exist, skipping
NOTICE:  table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE:  table "planet_osm_roads" does not exist, skipping
NOTICE:  table "planet_osm_roads_tmp" does not exist, skipping
Allocating memory for sparse node cache
Node-cache: cache=800MB, maxblocks=102401*zd, allocation method=8192
Mid: pgsql, scale=100 cache=800
Setting up table: planet_osm_nodes
NOTICE:  table "planet_osm_nodes" does not exist, skipping
Setting up table: planet_osm_ways
NOTICE:  table "planet_osm_ways" does not exist, skipping
Setting up table: planet_osm_rels
NOTICE:  table "planet_osm_rels" does not exist, skipping

Reading in file: F:\leisure.osm
StartElement: Unknown element name: note
Unknown node type 3
EndElement: Unknown element name: note
StartElement: Unknown element name: meta
EndElement: Unknown element name: meta
Processing: Node(123k 41.1k/s) Way(1253k 22.38k/s) Relation(0 0.00/s)
 parse tim
e: 59s

Node stats: total(123205), max(2944840119) in 3s
Way stats: total(1253181), max(291018582) in 56s
Relation stats: total(0), max(0) in 0s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending ways...
        1252534 ways are pending

Using 1 helper-processes
Helper process 0 out of 1 initialised
Process 0 finished processing 1252534 ways in 321 sec

All child processes exited

1252534 Pending ways took 321s at a rate of 3901.98/s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending relations...
        0 relations are pending

Using 1 helper-processes
Process 0 finished processing 0 relations in 0 sec

All child processes exited

node cache: stored: 123205(100.00%), storage efficiency: 50.00% (dense
blocks: 0
, sparse nodes: 123205), hit rate: 0.01%
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes in 0s
Stopping table: planet_osm_ways
Building index on table: planet_osm_ways (fastupdate=off)
Stopped table: planet_osm_ways in 282s
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels (fastupdate=off)
Stopped table: planet_osm_rels in 0s
Sorting data and creating indexes for planet_osm_point
Analyzing planet_osm_point finished
Copying planet_osm_point to cluster by geometry finished
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_point created  in 5s
Completed planet_osm_point
Sorting data and creating indexes for planet_osm_line
Analyzing planet_osm_line finished
Copying planet_osm_line to cluster by geometry finished
Creating indexes on  planet_osm_line finished
All indexes on  planet_osm_line created  in 0s
Completed planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
Analyzing planet_osm_polygon finished
Copying planet_osm_polygon to cluster by geometry finished
Creating indexes on  planet_osm_polygon finished
All indexes on  planet_osm_polygon created  in 1s
Completed planet_osm_polygon
Sorting data and creating indexes for planet_osm_roads
Analyzing planet_osm_roads finished
Copying planet_osm_roads to cluster by geometry finished
Creating indexes on  planet_osm_roads finished
All indexes on  planet_osm_roads created  in 0s
Completed planet_osm_roads

Osm2pgsql took 671s overall

C:\osm2pgsql\x64>


On Thu, Jul 3, 2014 at 8:43 PM, Paul Norman <notifications at github.com>
wrote:

> What does SELECT COUNT(*) FROM planet_osm_line report?
>
> Are the input files type then id sorted?
>
>> Reply to this email directly or view it on GitHub
> <https://github.com/openstreetmap/osm2pgsql/issues/165#issuecomment-47961456>
> .
>

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/165#issuecomment-47966123
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140703/cf3ce75c/attachment-0001.html>


More information about the Tile-serving mailing list