[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