Re: [gdal-dev] Issues specifying PostGIS connection details - possibly related to special characters in passwords?

2024-07-02 Thread Robin Wilson via gdal-dev
quot;the string 'robin' and the value of variable $42" before it gets into GDAL. My terminal would interpret it as the following: $ echo robin$42 robin and I'd need to escape the dollar symbol to get the text verbatim: $ echo robin\$42 robin$42 Cheers, Daniel On Tue, 2 Jul 2024

[gdal-dev] Issues specifying PostGIS connection details - possibly related to special characters in passwords?

2024-07-02 Thread Robin Wilson via gdal-dev
Hi, I’m using ogr2ogr to load a GeoPackage file into a PostGIS database. I initially tried using a command like this: ogr2ogr --debug ON -f PostgreSQL PG:"host= user= password=robin$42 dbname=data sslmode=require" file.gpkg -nln table_name However, this doesn’t work, and I always get an error:

[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 Postgr