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

[Alexandre Gacon]

Thanks even for the feedback. I have just spotted the nomd option but I
didn't get the time to test it.

Regards
Alexandre

Le mar. 11 juin 2024 à 17:43, Even Rouault <even.rouault at spatialys.com> a
écrit :

> 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 listgdal-dev at lists.osgeo.orghttps://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/20240612/824dbc92/attachment.htm>