Which version of PostGIS and PostgreSQL are you running? I think if you install with CREATE EXTENSION the permissions may not come back, but those should be public anyway. I believe in PostGIS 2.0.4 (or was it 2.0.3), can't remember, we changed to explicitly set these to public read since they are views and will only list tables user has access to.
Thanks, Regina http://www.postgis.us -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mario Jurcevic Sent: Monday, September 30, 2013 9:32 AM To: [email protected] Subject: [postgis-users] dump/restore permission Hi, after pg_dump/restore each time the permission on "geometry_columns" and "geography_columns" are lost. Why of that? Thanks. -- Mario _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
