[Tile-serving] [osm2pgsql-dev/osm2pgsql] How to keep the planet_osm_ways table without using the --slim option? (Discussion #2154)

Alexander Farber notifications at github.com
Tue Apr 2 09:25:28 UTC 2024


Hello dear osm2pgsql developers and users, when I run the following command:

`osm2pgsql --username=$PGUSER --database=$PGDATABASE --create --cache=60000 --hstore --latlong /data/map.osm.pbf`
then the **planet_osm_ways** table is not generated and I only have these tables:

```
osm_database=> \dt
               List of relations
 Schema |        Name        | Type  |  Owner   
--------+--------------------+-------+----------
 public | planet_osm_line    | table | osm_user
 public | planet_osm_point   | table | osm_user
 public | planet_osm_polygon | table | osm_user
 public | planet_osm_roads   | table | osm_user
 public | spatial_ref_sys    | table | postgres
(5 rows)
```

I need that table though, because in my application I use OSRM, get OSM node ids and then need to resolve them to parent OSM way ids.

I have tried adding the `-S default.style` as in the command below, but that has not helped:

`osm2pgsql --username=$PGUSER --database=$PGDATABASE --create -S /usr/share/osm2pgsql/default.style --cache=60000 --hstore --latlong /data/map.osm.pbf`

I do not want to introduce `--slim` option, because with it my Europe OSM import takes 10 hours instead of the current 3 hours.

Thank you
Alex

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2154
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2154 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240402/e957a1c5/attachment.htm>


More information about the Tile-serving mailing list