Hi, Hmm, I’m sure I tried escaping it before - but putting a \ in front of it fixed it - obviously I didn’t try properly before. Possibly I only tried quoting it in various ways. Thanks for the solution!
Now the thing I’m intrigued about is why it was working with the postgresql:// connection string but not the PG connection string… Best regards, Robin On 2 July 2024 at 17:08:18, Daniel Evans (daniel.fred.ev...@gmail.com) wrote: Hi Robin, Is this a shell issue, rather than a GDAL one? The dollar sign makes me suspect that a Unix shell is interpreting "robin$42" as "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 at 16:35, Robin Wilson via gdal-dev <gdal-dev@lists.osgeo.org> wrote: 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=<IP> user=<user> password=robin$42 dbname=data sslmode=require" file.gpkg -nln table_name However, this doesn’t work, and I always get an error: FATAL: password authentication failed for user “<user>" If I restructure the command to use the alternative postgresql:// connection string like this, then it works: ogr2ogr --debug ON -f PostgreSQL 'postgresql://<user>:robin$42@<IP>/data?sslmode=require’ file.gpkg -nln table_name I don’t remember running into this problem before when connecting to PostGIS databases using the PG: connection string, so I’m wondering whether my shell is doing something strange with my password? Obviously I don’t want to share my actual password, but it has a $ in it, and I wonder whether somehow this is causing problems - but only when using the PG: connection string. Any suggestions welcome, Best regards, Robin Dr Robin Wilson www.rtwilson.com _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
