Zobrazení zdroje stránky Diskuse:Cvičná databáze PostGIS

== Poznámky pro administraci ==

=== osm_routing ===

 ./osm2pgrouting -file ~/czech-republic-latest.osm -conf mapconfig.xml -dbname pgis_osm_rouring -user landa -passwd ...

<source lang=sql>
ALTER TABLE classes SET SCHEMA osm_routing;
ALTER TABLE nodes SET SCHEMA osm_routing;
ALTER TABLE relation_ways SET SCHEMA osm_routing;
ALTER TABLE relations SET SCHEMA osm_routing;
ALTER TABLE types SET SCHEMA osm_routing;
ALTER TABLE way_tag SET SCHEMA osm_routing;
ALTER TABLE ways SET SCHEMA osm_routing;
</source>

 pg_dump -Fc -b -v -f pgis_osm_routing.dump -n osm_routing pgis_osm_rouring
 postgis_restore.pl pgis_osm_routing.dump | psql pgis_student