<div dir="ltr"><div>Bár számomra nem kritikusan fontos, de osmose nem tudott csatlakozni rá. Sokféle képen próbáltam de sehogyan sem ment. Elméletileg így működnie kellene:</div><div><br></div><b>osmosis --read-apidb host="172.17.0.2" database="postgres" user="postgres" password="lQVdf4d3nj" --write-xml file="planet.osm"</b><br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.46<br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>log4j:WARN No appenders could be found for logger (org.springframework.jdbc.datasource.DataSourceTransactionManager).<br>log4j:WARN Please initialize the log4j system properly.<br>log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.<br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-apidb failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to create resultset.<br>    at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:431)<br>    at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:79)<br>    at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:53)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.runImpl(ApidbReader.java:74)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader$1.doInTransactionWithoutResult(ApidbReader.java:102)<br>    at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)<br>    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<br>    at org.openstreetmap.osmosis.apidb.common.DatabaseContext2.executeWithinTransaction(DatabaseContext2.java:94)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.run(ApidbReader.java:99)<br>    at java.lang.Thread.run(Thread.java:748)<br>Caused by: org.postgresql.util.PSQLException: ERROR: relation "schema_migrations" does not exist<br>  Position: 21<br>    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)<br>    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)<br>    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)<br>    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)<br>    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)<br>    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)<br>    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)<br>    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)<br>    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:233)<br>    at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:426)<br>    ... 9 more<br><br>Nov 18, 2018 2:12:09 AM org.openstreetmap.osmosis.core.Osmosis main<br>SEVERE: Execution aborted.<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.<br>    at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br>    at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br>    at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>    at java.lang.reflect.Method.invoke(Method.java:498)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)<br>    at org.codehaus.classworlds.Launcher.main(Launcher.java:47)<br><br><br><br>2018. november 18., vasárnap 1:27:49 UTC+1 időpontban Kovacs Szilveszter a következőt írta:<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><div dir="ltr"><div>Sziasztok!</div><div><br></div><div>Egy rövid leírást csináltam egy Dockerizált osm postgres adatbázis klónozásról. Azaz csak a magyar területről. Részben magamnak is csináltam emlékeztetőnek.<br></div><div><br></div><div>Ha tetszik, akkor később beemelhetem a wikibe is.</div><div><br></div><div><span style="background-color:rgb(255,255,0)">Docker fájlok letöltése GIT-ről</span><br></div><code>sly@sly: ~/Documents/HOME/mypgisdb/<wbr>osm2pgsql$<b> git clone <a href="https://github.com/OsmHackTW/osm2pgsql-docker.git" target="_blank" rel="nofollow" onmousedown="this.href='https://www.google.com/url?q\x3dhttps%3A%2F%2Fgithub.com%2FOsmHackTW%2Fosm2pgsql-docker.git\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEoq5_cWVJSLxVgFn7oG6mf3nO6eg';return true;" onclick="this.href='https://www.google.com/url?q\x3dhttps%3A%2F%2Fgithub.com%2FOsmHackTW%2Fosm2pgsql-docker.git\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEoq5_cWVJSLxVgFn7oG6mf3nO6eg';return true;">https://github.com/OsmHackTW/<wbr>osm2pgsql-docker.git</a></b><br>Cloning into 'osm2pgsql-docker'...<br>remote: Enumerating objects: 116, done.<br>remote: Total 116 (delta 0), reused 0 (delta 0), pack-reused 116<br>Receiving objects: 100% (116/116), 16.41 KiB | 190.00 KiB/s, done.<br>Resolving deltas: 100% (51/51), done.<br></code><code></code><div><br></div><div><code><code><br>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql$ <b>cd osm2pgsql-docker/</b><br></code></code></div><div><br><code><code><span style="background-color:rgb(255,255,0)">Futtathatóvá tétel<br></span></code></code></div><div><code><code><span style="background-color:rgb(255,255,0)"></span>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql/osm2pgsql-<wbr>docker$ <b>chmod +x run.sh</b></code></code></div><div><code><code><code><code>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql/osm2pgsql-<wbr>docker$ <b>chmod +x </b></code></code></code></code><b><code><code><code><code><code><code>postgis</code></code>.sh</code></code></code></code></b></div><div><br><code><code><code><code></code></code></code></code></div><div><br><code><code><span style="background-color:rgb(255,255,0)">Postgis DB letöltése és indítása<br></span></code></code></div><div><code><code>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql/osm2pgsql-<wbr>docker$ <b>sudo ./postgis.sh</b><br>[sudo] password for sly:<br>Unable to find image 'osmtw/postgis:latest' locally<br><br>latest: Pulling from osmtw/postgis<br>f2aa67a397c4: Pull complete<br><i>[...]</i><br>d5d0857dfa92: Pull complete<br>Digest: sha256:<wbr>7b5096f988ca99e7ea904e968dacf4<wbr>8f0c4dd4c9f3cfe11f025d2ed6e215<wbr>3d1e<br>Status: Downloaded newer image for osmtw/postgis:latest<br>d12745342012af7bb5f9ae643864d9<wbr>821eb172e61afc8c59dc212440aa49<wbr>d386<br><br></code></code><br><code><code><code><code><span style="background-color:rgb(255,255,0)">Postgis DB frissítő letöltése és indítása</span></code></code></code></code></div><div><code><code><code><code><span style="background-color:rgb(255,255,0)"></span></code></code>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql/osm2pgsql-<wbr>docker$ <b>sudo ./run.sh</b><br>Unable to find image 'osmtw/osm2pgsql:0.96.0' locally<br>docker: Error response from daemon: manifest for osmtw/osm2pgsql:0.96.0 not found.<br>See 'docker run --help'.</code></code></div><div><code><code><br></code></code></div><div><code><code><br></code></code></div><div><span style="background-color:rgb(255,255,0)"><code><code><br></code></code></span></div><div><code><code><span style="background-color:rgb(255,255,0)">Valamiért nem működik a v96-al ezért átállítom a run.sh-ban verziót. Ha már erre járok az országot is:</span><br></code></code></div><div><code><code><div style="background-color:rgb(250,250,250);border-color:rgb(187,187,187);border-style:solid;border-width:1px"><code><div><span style="color:#800">#!/bin/bash</span><span style="color:#000"><br>POSTGIS_INSTANCE</span><span style="color:#660">=</span><span style="color:#000">$</span><span style="color:#660">{</span><span style="color:#066">1</span><span style="color:#660">:-</span><span style="color:#080">"osmdb"</span><span style="color:#660">}</span><span style="color:#000"><br>REGION</span><span style="color:#660">=</span><span style="color:#000">$</span><span style="color:#660">{</span><span style="color:#066">2</span><span style="color:#660">:-</span><span style="color:#080">"</span><span style="background-color:rgb(255,255,0)"><span style="color:#080">europe/hungary</span></span><span style="color:#080">"</span><span style="color:#660">}</span><span style="color:#000"><br>DATADIR</span><span style="color:#660">=</span><span style="color:#080">/osm<br>LOOP=600<br>VERSION=${3:-"</span><span style="background-color:rgb(255,255,0)"><span style="color:#080">0.90.1</span></span><span style="color:#080">"}<br><br>docker run -t -i --rm \<br>    --link ${POSTGIS_INSTANCE}:pg \<br>    -e REGION=$REGION \<br>    -e DATADIR=$DATADIR \<br>    -e LOOP=$LOOP \<br>    -v ${POSTGIS_INSTANCE}-volume:$<wbr>DATADIR \<br>    --name osm2pgsql \<br>    osmtw/</span><span style="color:#000">osm2pgsql</span><span style="color:#660">:</span><span style="color:#000">$</span><span style="color:#660">{</span><span style="color:#000">VERSION</span><span style="color:#660">}</span><span style="color:#000"><br></span></div></code></div><br><br></code></code></div><div><code><code><span style="background-color:rgb(255,255,0)">Ezekután újra próbálkozás</span><br></code></code></div><div><code><code><br>sly@sly:~/Documents/HOME/<wbr>mypgisdb/osm2pgsql/osm2pgsql-<wbr>docker$ <b>sudo ./run.sh</b><br>Unable to find image 'osmtw/osm2pgsql:0.90.1' locally<br>0.90.1: Pulling from osmtw/osm2pgsql<br>297061f60c36: Already exists<br>[...]<br>eafdf1df5b82: Pull complete<br>Digest: sha256:<wbr>5b4a511fb29cf30b12275e9cf84b21<wbr>e497211045d002aeb7c905fc14ef95<wbr>daaa<br>Status: Downloaded newer image for osmtw/osm2pgsql:0.90.1<br>REGION=europe/hungary<br>COUNTRY=hungary<br>DATADIR=/osm<br>PBF=/osm/hungary-latest.osm.<wbr>pbf<br>LOOP=600<br> ?column?<br>----------<br>        1<br>(1 row)<br><br>--2018-11-17 23:34:35--  <a href="http://download.geofabrik.de/europe/hungary-latest.osm.pbf" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de%2Feurope%2Fhungary-latest.osm.pbf\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGQXj5Hlffm0XnCs5ziUkKe45ojHg';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de%2Feurope%2Fhungary-latest.osm.pbf\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGQXj5Hlffm0XnCs5ziUkKe45ojHg';return true;">http://download.geofabrik.de/<wbr>europe/hungary-latest.osm.pbf</a><br>Resolving <a href="http://download.geofabrik.de" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;">download.geofabrik.de</a> (<a href="http://download.geofabrik.de" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;">download.geofabrik.de</a>)... 88.99.105.98, 88.99.24.113<br>Connecting to <a href="http://download.geofabrik.de" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;">download.geofabrik.de</a> (<a href="http://download.geofabrik.de" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGDTcEc9oUuK0f93jtBM8HCjvcu1w';return true;">download.geofabrik.de</a>)|88.99.<wbr>105.98|:80... connected.<br>HTTP request sent, awaiting response... 200 OK<br>Length: 152091283 (145M) [application/octet-stream]<br>Saving to: '/osm/sy8.pbf'<br><br>/osm/sy8.pbf                  <wbr>                       100%[=========================<wbr>==============================<wbr>==============================<wbr>==============================<wbr>==>] 145.04M  2.64MB/s    in 64s    <br><br>2018-11-17 23:35:39 (2.26 MB/s) - '/osm/sy8.pbf' saved [152091283/152091283]<br><br>osm2pgsql SVN version 0.90.1-dev (64 bit id space)<br><br>Using built-in tag processing pipeline<br>Using projection SRS 900913 (Spherical Mercator)<br>Setting up table: planet_osm_point<br>Setting up table: planet_osm_line<br>Setting up table: planet_osm_polygon<br>Setting up table: planet_osm_roads<br>Allocating memory for dense node cache<br>Allocating dense node cache in one big chunk<br>Allocating memory for sparse node cache<br>Sharing dense sparse<br>Node-cache: cache=2000MB, maxblocks=32000*65536, allocation method=11<br>Mid: pgsql, scale=100 cache=2000<br>Setting up table: planet_osm_nodes<br>Setting up table: planet_osm_ways<br>Setting up table: planet_osm_rels<br><br>Reading in file: /osm/sy8.pbf<br>Using PBF parser.<br>Processing: Node(16565k 233.3k/s) Way(2264k 73.06k/s) Relation(81750 286.84/s)  parse time: 387s<br>Node stats: total(16565415), max(6067328962) in 71s<br>Way stats: total(2264858), max(645435423) in 31s<br>Relation stats: total(81751), max(8971464) in 285s<br>Committing transaction for planet_osm_point<br>[...]<br>Setting up table: planet_osm_rels<br>Using built-in tag processing pipeline<br><br>Going over pending ways...<br>    1326922 ways are pending<br><br>Using 8 helper-processes<br>Finished processing 1326922 ways in 58 s<br><br>1326922 Pending ways took 58s at a rate of 22877.97/s<br>Committing transaction for planet_osm_point<br>[...]<br>Stopped table: planet_osm_rels in 1s<br>node cache: stored: 16565415(100.00%), storage efficiency: 50.17% (dense blocks: 64, sparse nodes: 16247848), hit rate: 100.20%<br><br>Osm2pgsql took 596s overall<br>'/osm/sy8.pbf' -> '/osm/hungary-latest.osm.pbf'<br><br><br> ?column?<br>----------<br>        1<br>(1 row)<br><br>osmupdate Parameter: --base-url=<a href="http://download.geofabrik.de/europe/hungary-updates" target="_blank" rel="nofollow" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de%2Feurope%2Fhungary-updates\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFEQWMr18hzTqLm972TY9wY7xFMSw';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fdownload.geofabrik.de%2Feurope%2Fhungary-updates\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFEQWMr18hzTqLm972TY9wY7xFMSw';return true;">download.geofabrik.<wbr>de/europe/hungary-updates</a><br>osmupdate Parameter: /osm/hungary-latest.osm.pbf<br>osmupdate Parameter: /osm/kNe.pbf<br>osmupdate: timestamp of /osm/hungary-latest.osm.pbf: 2018-11-16T21:14:03Z<br>osmupdate: newest sporadic timestamp: 2018-11-16T21:14:03Z<br>osmupdate: Found status information in base URL root.<br>osmupdate: Ignoring subdirectories "minute", "hour", "day".<br>osmupdate: Creating output file.<br>osmupdate: Your OSM file is already up-to-date.<br></code></code></div><div><br><code><code></code></code></div><div><br><code><code></code></code></div><div><span style="background-color:rgb(255,255,0)"><code><code>Ekkor lefutott az import is.</code></code></span></div><div><br><code><code></code></code></div><div><b><code><code>Elérhetőség ellenőrzése.</code></code></b></div><div><code><code><br></code></code></div><div><span style="background-color:rgb(255,255,0)"><code><code>Információk lekérése:</code></code></span></div><div><code><code><b>sudo docker exec osmdb env</b><br>PATH=/usr/local/sbin:/usr/<wbr>local/bin:/usr/sbin:/usr/bin:/<wbr>sbin:/bin:/usr/lib/postgresql/<wbr>10/bin<br>HOSTNAME=d12745342012<br><b>POSTGRES_PASSWORD=lQVddc4d3nj</b><br><b>POSTGRES_USER=postgres</b><br><b>POSTGRES_DB=postgres</b><br>GOSU_VERSION=1.10<br>LANG=en_US.utf8<br>PG_MAJOR=10<br>PG_VERSION=10.4-2.pgdg90+1<br>PGDATA=/var/lib/postgresql/<wbr>data<br>POSTGIS_MAJOR=2.4<br>POSTGIS_VERSION=2.4.4+dfsg-1.<wbr>pgdg90+1<br>HOME=/root<br></code></code></div><div><code><code><br></code></code></div><div><code><code><span style="background-color:rgb(255,255,0)">IP:</span><br></code></code></div><div><code><code><b>sudo docker exec osmdb bash -c 'hostname -I'</b><br>172.17.0.2 <br></code></code></div><div><code><code><br></code></code></div><div><span style="background-color:rgb(255,255,0)"><code><code>Kapcsolódás az adatbázishoz:</code></code></span></div><div><code><code><b>psql -h 172.17.0.2 -U postgres -p 5432 -l</b><br>Password for user postgres: <br>                              <wbr>      List of databases<br>       Name       |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   <br>------------------+----------+<wbr>----------+------------+------<wbr>------+-----------------------<br> postgres         | postgres | UTF8     | en_US.utf8 | en_US.utf8 | <br> template0        | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +<br>                  |          |          |            |            | postgres=CTc/postgres<br> template1        | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +<br>                  |          |          |            |            | postgres=CTc/postgres<br> template_postgis | postgres | UTF8     | en_US.utf8 | en_US.utf8 | <br>(4 rows)<br></code></code></div><div><code><code><br></code></code></div><div><code><code><b> sudo docker ps</b><br>[sudo] password for sly: <br>CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS              PORTS               NAMES<br>847f6527107c        osmtw/osm2pgsql:0.90.1   "/bin/bash -i /usr/l…"   8 minutes ago       Up 7 minutes                       <wbr>     osm2pgsql<br>d12745342012        osmtw/postgis            "docker-entrypoint.s…"   22 minutes ago      Up 21 minutes       5432/tcp            osmdb<br><br></code></code></div><div><code><code><br></code></code></div><div><code><code><br></code></code></div><div><code><code><b>Megjegyzés:</b><br></code></code></div><div><code><code>Ha jól sejtem 600 másodpercenként frissül az adatbázis, amit az </code></code><code><code>osm2pgsql docker csinál.</code></code></div><div><code><code></code></code><code><code>osmdb maga az adatbázis.</code></code><br><code><code></code></code></div></div></blockquote></div>