[Tile-serving] [openstreetmap/osm2pgsql] Stuck on PREPARE get_wkb(int8) AS SELECT way FROM "planet_osm_roads" WHERE osm_id = $1 (#1515)

Oscar Corredor notifications at github.com
Tue Jun 1 23:56:49 UTC 2021


Hi, I'm trying to process a country file downloaded from geofabrik, however the process gets stuck in the _Setting up table 'planet_osm_roads'_ step. More specifically, the SQL log shows that it's on the following query: 

`SQL: PREPARE get_wkb(int8) AS SELECT way FROM "planet_osm_roads" WHERE osm_id = $1
`
My versions are the following:
osm2pgsql - 1.4.2
postgres: 12.7
Postgis: 3.0

The command I am using to execute osm2pgsql is the following
`osm2pgsql -r pbf -s -d osm -l -v -C 15000 --slim --drop --number-processes=8 -U odco -W - localhost -P 5432 --log-level='debug' --log-sql --log-sql-data colombia-latest.osm.pbf`

How can I fix this issue? Any help will be appreciated, thanks in advance.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1515
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210601/65ae739f/attachment.htm>


More information about the Tile-serving mailing list