Hi folks,
I'm running Postgres / PostGIS on AWS RDS, and I recently upgrade from Postgres
9.4 to 9.5, and from Postgis 2.1 to 2.2.
The Postgres upgrade was carried out via AWS's managed upgrade process. The
PostGIS upgrade was carried out with ALTER EXTENSION POSTGIS UPDATE TO '2.2.2'.
Following the upgrade, I have lost permissions on the geometry_columns and
raster_columns views. Certain actions, such as an ogr2ogr export, fail with the
message:
ERROR: permission denied for relation geometry_columns
I have tried to use GRANT to recover the permissions, but I receive the same
error message. I cannot see the content of this view, and it no longer appears
in information_schema.tables
Has anyone experienced this issue when upgrading AWS RDS Postgres and, if so,
how did you get around it?
I appreciate this is a limitation of RDS, as I could use GRANT if I had the
required superuser access. Nonetheless, I thought the PostGIS community might
have experience in this area.
▬▬▬ι═══════════ﺤ
Timothy Asquith // Red Ronin
[email protected]
www.redronin.io
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
