This has to do with the way permissions are set up in your PostgreSQL database: the database user you’re using to connect to the database does not have the permissions necessary to update PostGIS tables.
Try this in the PostgreSQL console: GRANT select, insert, update, delete ON spatial_ref_sys to <your_postgres_username>; … substituting the actual username you’re connecting with for "<your_postgres_username>”. It’s likely that you will have to do this for the geometry_columns table as well, maybe others. m. > On 25 Mar 2016, at 20:15, Saikat Basu <[email protected]> wrote: > > Hi everyone, > While trying to install the OSM Task Manager, I followed all the steps > mentioned in the wiki. However, while trying to initialize the database using > the script provided in the wiki, > ./env/bin/initialize_osmtm_db > > I got the error: > > sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied for > relation spatial_ref_sys > > CONTEXT: SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = > 4326 LIMIT 1" > > > 'SELECT > ST_AsBinary(ST_Transform(ST_SetSRID(ST_Multi(ST_GeomFromWKB(%(ST_GeomFromWKB_1)s, > %(ST_GeomFromWKB_2)s)), %(param_1)s), %(param_2)s)) AS "ST_Transform_1"' > {'ST_GeomFromWKB_1': <read-only buffer for 0x2f2e690, size -1, offset 0 at > 0x2f36fb0>, 'param_2': 3857, 'param_1': 4326, 'ST_GeomFromWKB_2': 4326} > > Can anyone please help me figure out the problem? Thanks. > > -- > Saikat Basu > Department of Computer Science > Louisiana State University > USA > > _______________________________________________ > HOT mailing list > [email protected] > https://lists.openstreetmap.org/listinfo/hot _______________________________________________ HOT mailing list [email protected] https://lists.openstreetmap.org/listinfo/hot
