[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