User:Nakor/Osmosis Postgis Fedora

From OpenStreetMap Wiki
Jump to: navigation, search

yum install postgresql postgis postgresql-server postgresql-contrib

service postgresql initdb

service postgresql start

su - postgres

createuser osmuser

createdb osm

createlang plpgsql osm

psql -d osm -f /usr/share/pgsql/contrib/postgis-64.sql

psql -d osm -f /usr/share/pgsql/contrib/spatial_ref_sys.sql

psql -d osm -f /usr/share/pgsql/contrib/hstore.sql

psql -d osm -f /tmp/script/pgsql_simple_schema_0.6.sql

psql -d osm -f /tmp/script/pgsql_simple_schema_0.6_action.sql

psql -d osm -f /tmp/script/pgsql_simple_schema_0.6_bbox.sql

psql -d osm -f /tmp/script/pgsql_simple_schema_0.6_linestring.sql