[gdal-dev] ogr2ogr no longer works with non super user in PG after update

[Even Rouault]

Hi,

The issue has been reported in https://github.com/OSGeo/gdal/issues/9994 
and should be be fixed in 3.9.1 per 
https://github.com/OSGeo/gdal/pull/10004 (testing of the 3.9 branch at 
https://github.com/OSGeo/gdal/tree/release/3.9 would be appreciated to 
confirm that it fixes error for various permission scenarios)

You can typically get the error with 3.9.0 when importing a shapefile 
since there is a layer metadata item set on the shapefile layer when 
reading it, that gets automatically imported by ogr2ogr. You can 
workaround the issue by specifying the "-nomd" ogr2ogr option

Even

Le 11/06/2024 à 17:33, Alexandre Gacon via gdal-dev a écrit :
> Hello there,
>
> After updating our stack from GDAL 3.4.1 to GDAL 3.9.0, we have 
> ogr2ogr calls which no longer succeed with the following message:
>
> ERROR: permission denied to create event trigger 
> "ogr_system_tables_event_trigger_for_metadata".  HINT:  Must be 
> superuser to create an event trigger.
>
> If I dig in the codebase, it is related to a change named "
> PG: serialize GDAL multidomain metadata of layer as XML in a 
> ogr_system_tables.metadata table"
>
> We don't have multidomain in our data: is it mandatory no to use a 
> superuser when importing data into a PG DB with ogr2ogr or is there a 
> way to dismiss this message?
>
> Regards
>
> -- 
> Alexandre Gacon
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20240611/261ee533/attachment.htm>