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. _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
