[OSM-talk] Problems setting up Osmosis and Postgres SQL

Alberto albertolara at gmail.com
Thu Sep 1 07:52:16 BST 2011


Heya,
Same problem. 
If you use \d command into psql you will see all tables have "postgres"
owner. You must assign them your user.

ALTER TABLE geometry_columns OWNER TO <your_user>;
ALTER TABLE nodes OWNER TO  <your_user>;
ALTER TABLE relation_members OWNER TO  <your_user>;
ALTER TABLE relations OWNER TO  <your_user>;
ALTER TABLE schema_info OWNER TO  <your_user>;
ALTER TABLE spatial_ref_sys OWNER TO  <your_user>;
ALTER TABLE users OWNER TO  <your_user>;
ALTER TABLE way_nodes OWNER TO  <your_user>;
ALTER TABLE ways OWNER TO  <your_user>;

After it, execute osmosis with --write-pgsql if you use pg_snapsnot schema
or --write-pgsimple if pg_simple schema used
Cheers.



--
View this message in context: http://gis.638310.n2.nabble.com/Problems-setting-up-Osmosis-and-Postgres-SQL-tp5989414p6749107.html
Sent from the General Discussion mailing list archive at Nabble.com.



More information about the talk mailing list