[Tile-serving] [openstreetmap/osm2pgsql] Osm2pgsql 1.6 data dump to specific schema of DB (Discussion #1686)

Deepanshu Rai notifications at github.com
Fri Jun 24 11:50:09 UTC 2022


While using osm2pgsql 1.6 i am trying to dump PBF into specific schema of postgres DB using following commands using docker. (i am setting database properties in docker env)

docker run -v /mnt/ne-blobs/:/mnt/ne-blobs/ --env PGHOST=$PGHOST --env PGPORT=$PGPORT --env PGUSER=$PGUSER --env PGDATABASE=$PGDATABASE --env PGPASSWORD=$PGPASSWORD osm2pgsql:1.6.0 **osm2pgsql -c -E 4326 --hstore --slim -C 8000 --output-pgsql-schema=$schema_name -r pbf /path/to/pbf.**

I am creating schema before executing this command but i see that only 
planet_osm_line, planet_osm_point, planet_osm_polygon, planet_osm_roads

are getting created in my mentioned schema

but core tables like Planet_osm_nodes, planet_osm_rels ,planet_osm_ways

are getting created in public schema. Is there anything i am doing wrong with the command? i want to create all 7 tables in one schema which is execution specific.

what is the role of --middle-schema ?? 

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

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


More information about the Tile-serving mailing list