Re: [gdal-dev] Hanging (or very slow) when ogr2ogr appending to PostGIS table

2024-03-14 Thread Even Rouault via gdal-dev
(re-adding list) Le 14/03/2024 à 18:58, Robin Wilson a écrit : Hi Even, Perfect - adding —config PG_USE_COPY YES solved it. I’ll write a blog post about this that hopefully will be found by someone with the same issue in future. You may also suggest documentation enhancement to

Re: [gdal-dev] Hanging (or very slow) when ogr2ogr appending to PostGIS table

2024-03-14 Thread Even Rouault via gdal-dev
Robin, - output of "gdalinfo --version" ? - try adding ``--config PG_USE_COPY YES`` to  the command line where you append to the existing table. Cf https://gdal.org/drivers/vector/pg.html#configuration-options (copy mode is enabled by default at table creation, but not in append scenarios)

[gdal-dev] Hanging (or very slow) when ogr2ogr appending to PostGIS table

2024-03-14 Thread Robin Wilson via gdal-dev
Hi, I’ve been using ogr2ogr to import vector datasets into PostGIS tables. I originally tried this using a local Postgres server, and ran the following commands to import one file into a PostGIS table, and then append the contents of another file to the same table: ogr2ogr --debug ON -f