I think the trick there is that single quotes make most shells consider a string verbatim - I'd forgotten that part! That's probably the more desirable solution, actually.
Cheers, Daniel On Tue, 2 Jul 2024, 17:13 Robin Wilson, <ro...@rtwilson.com> wrote: > 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
