How to set the target schema using osm2pgrouting

Question

Is it possible to set the target database schema using osm2pgrouting?

After some debate and troubleshooting, I've decided to host my OSM-based pgRouting data in the same database as the rest of my data, but want to use a different schema (one big issue was using dblink, which I can't get to work anyway).

However, osm2pgrouting doesn't expose the ability to specify the target schema.

• Vicky: I added the feature request to osm2pgrouting
• Inactivated Account: @Vicky that's great! I much appreciate that!!!

Answer 1

Only way I've been able to do it (I think it works for osm2pgrouting, but haven't tried recently)

Is to first change the search_path of your database temporarily so preferred schema is first:

ALTER DATABASE yourdb SET search_path = osm_data, public;

Then run osm2pgrouting

Alternatively you could create a user specifically for loading and then set the search_path for that user (or name the same as the schema) assuming you didn't mess with your db search_path.

ALTER ROLE osm_user IN DATABASE yourdb
 SET search_path = osm_data,public;

then always load with that user.

It's not ideal I know. Probably worthwhile putting in a feature request here: https://github.com/pgRouting/osm2pgrouting

• Inactivated Account: that's great - worked like a charm. Barring the feature request now in osm2pgrouting, this is a great workaround...thanks again!
• Regina Obe: BTW I recently added the schema feature in osm2pgrouitng. So should show in next release. github.com/pgRouting/osm2pgrouting/tree/with-schema