API tools faq
paste
Advertisement
Guest User

osm2psql output

a guest
Aug 31st, 2017
647
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 10.49 KB | None | 0 0
raw download clone embed print report
  1. osm2pgsql SVN version 0.88.1 (64bit id space)
  2.  
  3. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  4. Using projection SRS 900913 (Spherical Mercator)
  5. Setting up table: planet_osm_point
  6. Setting up table: planet_osm_line
  7. Setting up table: planet_osm_polygon
  8. Setting up table: planet_osm_roads
  9. Allocating memory for dense node cache
  10. Allocating dense node cache in one big chunk
  11. Allocating memory for sparse node cache
  12. Sharing dense sparse
  13. Node-cache: cache=18000MB, maxblocks=2304000*8192, allocation method=11
  14. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  15. Allocated space for persistent node cache file
  16. Maximum node in persistent node cache: 0
  17. Mid: pgsql, scale=100 cache=18000
  18. Setting up table: planet_osm_nodes
  19. Setting up table: planet_osm_ways
  20. Setting up table: planet_osm_rels
  21.  
  22. Reading in file: /mnt/db/planet.osm.pbf
  23. Processing: Node(4035672k 631.6k/s) Way(431724k 8.69k/s) Relation(5175690 159.05/s)  parse time: 88597s
  24. Node stats: total(4035672578), max(5047121925) in 6390s
  25. Way stats: total(431724615), max(517122423) in 49665s
  26. Relation stats: total(5175696), max(7492976) in 32542s
  27. Maximum node in persistent node cache: 5047844863
  28. Committing transaction for planet_osm_point
  29. Committing transaction for planet_osm_line
  30. Committing transaction for planet_osm_polygon
  31. Committing transaction for planet_osm_roads
  32. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  33. Maximum node in persistent node cache: 5047844863
  34. Setting up table: planet_osm_nodes
  35. Setting up table: planet_osm_ways
  36. Setting up table: planet_osm_rels
  37. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  38. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  39. Maximum node in persistent node cache: 5047844863
  40. Setting up table: planet_osm_nodes
  41. Setting up table: planet_osm_ways
  42. Setting up table: planet_osm_rels
  43. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  44. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  45. Maximum node in persistent node cache: 5047844863
  46. Setting up table: planet_osm_nodes
  47. Setting up table: planet_osm_ways
  48. Setting up table: planet_osm_rels
  49. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  50. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  51. Maximum node in persistent node cache: 5047844863
  52. Setting up table: planet_osm_nodes
  53. Setting up table: planet_osm_ways
  54. Setting up table: planet_osm_rels
  55. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  56. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  57. Maximum node in persistent node cache: 5047844863
  58. Setting up table: planet_osm_nodes
  59. Setting up table: planet_osm_ways
  60. Setting up table: planet_osm_rels
  61. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  62. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  63. Maximum node in persistent node cache: 5047844863
  64. Setting up table: planet_osm_nodes
  65. Setting up table: planet_osm_ways
  66. Setting up table: planet_osm_rels
  67. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  68. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  69. Maximum node in persistent node cache: 5047844863
  70. Setting up table: planet_osm_nodes
  71. Setting up table: planet_osm_ways
  72. Setting up table: planet_osm_rels
  73. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  74. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  75. Maximum node in persistent node cache: 5047844863
  76. Setting up table: planet_osm_nodes
  77. Setting up table: planet_osm_ways
  78. Setting up table: planet_osm_rels
  79. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  80. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  81. Maximum node in persistent node cache: 5047844863
  82. Setting up table: planet_osm_nodes
  83. Setting up table: planet_osm_ways
  84. Setting up table: planet_osm_rels
  85. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  86. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  87. Maximum node in persistent node cache: 5047844863
  88. Setting up table: planet_osm_nodes
  89. Setting up table: planet_osm_ways
  90. Setting up table: planet_osm_rels
  91. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  92.  
  93. Going over pending ways...
  94.     287961768 ways are pending
  95.  
  96. Using 10 helper-processes
  97. Finished processing 287961768 ways in 24511 sec
  98.  
  99. 287961768 Pending ways took 24511s at a rate of 11748.27/s
  100. Committing transaction for planet_osm_point
  101. Committing transaction for planet_osm_line
  102. Committing transaction for planet_osm_polygon
  103. Committing transaction for planet_osm_roads
  104. Committing transaction for planet_osm_point
  105. Committing transaction for planet_osm_line
  106. Committing transaction for planet_osm_polygon
  107. Committing transaction for planet_osm_roads
  108. Committing transaction for planet_osm_point
  109. Committing transaction for planet_osm_line
  110. Committing transaction for planet_osm_polygon
  111. Committing transaction for planet_osm_roads
  112. Committing transaction for planet_osm_point
  113. Committing transaction for planet_osm_line
  114. Committing transaction for planet_osm_polygon
  115. Committing transaction for planet_osm_roads
  116. Committing transaction for planet_osm_point
  117. Committing transaction for planet_osm_line
  118. Committing transaction for planet_osm_polygon
  119. Committing transaction for planet_osm_roads
  120. Committing transaction for planet_osm_point
  121. Committing transaction for planet_osm_line
  122. Committing transaction for planet_osm_polygon
  123. Committing transaction for planet_osm_roads
  124. Committing transaction for planet_osm_point
  125. Committing transaction for planet_osm_line
  126. Committing transaction for planet_osm_polygon
  127. Committing transaction for planet_osm_roads
  128. Committing transaction for planet_osm_point
  129. Committing transaction for planet_osm_line
  130. Committing transaction for planet_osm_polygon
  131. Committing transaction for planet_osm_roads
  132. Committing transaction for planet_osm_point
  133. Committing transaction for planet_osm_line
  134. Committing transaction for planet_osm_polygon
  135. Committing transaction for planet_osm_roads
  136. Committing transaction for planet_osm_point
  137. Committing transaction for planet_osm_line
  138. Committing transaction for planet_osm_polygon
  139. Committing transaction for planet_osm_roads
  140.  
  141. Going over pending relations...
  142.     0 relations are pending
  143.  
  144. Using 10 helper-processes
  145. Finished processing 0 relations in 0 sec
  146.  
  147. Committing transaction for planet_osm_point
  148. WARNING:  there is no transaction in progress
  149. Committing transaction for planet_osm_line
  150. WARNING:  there is no transaction in progress
  151. Committing transaction for planet_osm_polygon
  152. WARNING:  there is no transaction in progress
  153. Committing transaction for planet_osm_roads
  154. WARNING:  there is no transaction in progress
  155. Committing transaction for planet_osm_point
  156. WARNING:  there is no transaction in progress
  157. Committing transaction for planet_osm_line
  158. WARNING:  there is no transaction in progress
  159. Committing transaction for planet_osm_polygon
  160. WARNING:  there is no transaction in progress
  161. Committing transaction for planet_osm_roads
  162. WARNING:  there is no transaction in progress
  163. Committing transaction for planet_osm_point
  164. WARNING:  there is no transaction in progress
  165. Committing transaction for planet_osm_line
  166. WARNING:  there is no transaction in progress
  167. Committing transaction for planet_osm_polygon
  168. WARNING:  there is no transaction in progress
  169. Committing transaction for planet_osm_roads
  170. WARNING:  there is no transaction in progress
  171. Committing transaction for planet_osm_point
  172. WARNING:  there is no transaction in progress
  173. Committing transaction for planet_osm_line
  174. WARNING:  there is no transaction in progress
  175. Committing transaction for planet_osm_polygon
  176. WARNING:  there is no transaction in progress
  177. Committing transaction for planet_osm_roads
  178. WARNING:  there is no transaction in progress
  179. Committing transaction for planet_osm_point
  180. WARNING:  there is no transaction in progress
  181. Committing transaction for planet_osm_line
  182. WARNING:  there is no transaction in progress
  183. Committing transaction for planet_osm_polygon
  184. WARNING:  there is no transaction in progress
  185. Committing transaction for planet_osm_roads
  186. WARNING:  there is no transaction in progress
  187. Committing transaction for planet_osm_point
  188. WARNING:  there is no transaction in progress
  189. Committing transaction for planet_osm_line
  190. WARNING:  there is no transaction in progress
  191. Committing transaction for planet_osm_polygon
  192. WARNING:  there is no transaction in progress
  193. Committing transaction for planet_osm_roads
  194. WARNING:  there is no transaction in progress
  195. Committing transaction for planet_osm_point
  196. WARNING:  there is no transaction in progress
  197. Committing transaction for planet_osm_line
  198. WARNING:  there is no transaction in progress
  199. Committing transaction for planet_osm_polygon
  200. WARNING:  there is no transaction in progress
  201. Committing transaction for planet_osm_roads
  202. WARNING:  there is no transaction in progress
  203. Committing transaction for planet_osm_point
  204. WARNING:  there is no transaction in progress
  205. Committing transaction for planet_osm_line
  206. WARNING:  there is no transaction in progress
  207. Committing transaction for planet_osm_polygon
  208. WARNING:  there is no transaction in progress
  209. Committing transaction for planet_osm_roads
  210. WARNING:  there is no transaction in progress
  211. Committing transaction for planet_osm_point
  212. WARNING:  there is no transaction in progress
  213. Committing transaction for planet_osm_line
  214. WARNING:  there is no transaction in progress
  215. Committing transaction for planet_osm_polygon
  216. WARNING:  there is no transaction in progress
  217. Committing transaction for planet_osm_roads
  218. WARNING:  there is no transaction in progress
  219. Committing transaction for planet_osm_point
  220. WARNING:  there is no transaction in progress
  221. Committing transaction for planet_osm_line
  222. WARNING:  there is no transaction in progress
  223. Committing transaction for planet_osm_polygon
  224. WARNING:  there is no transaction in progress
  225. Committing transaction for planet_osm_roads
  226. WARNING:  there is no transaction in progress
  227. Sorting data and creating indexes for planet_osm_point
  228. Sorting data and creating indexes for planet_osm_line
  229. Sorting data and creating indexes for planet_osm_polygon
  230. Sorting data and creating indexes for planet_osm_roads
  231. Stopping table: planet_osm_nodes
  232. Stopping table: planet_osm_ways
  233. Building index on table: planet_osm_ways
  234. Stopping table: planet_osm_rels
  235. Building index on table: planet_osm_rels
  236. Stopped table: planet_osm_nodes in 0s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!