<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body><div style="font-family:Helvetica,Arial;font-size:13px; ">Hi,</div><div style="font-family:Helvetica,Arial;font-size:13px; "><br></div><div style="font-family:Helvetica,Arial;font-size:13px; ">I’m using ogr2ogr to load a GeoPackage file into a PostGIS database. I initially tried using a command like this:</div><div style="font-family:Helvetica,Arial;font-size:13px; "><br></div><div style="font-family:Helvetica,Arial;font-size:13px; ">ogr2ogr --debug ON -f PostgreSQL PG:"host=<IP> user=<user> password=robin$42 dbname=data sslmode=require" file.gpkg -nln table_name</div><div style="font-family:Helvetica,Arial;font-size:13px; "><br></div><div style="font-family:Helvetica,Arial;font-size:13px; ">However, this doesn’t work, and I always get an error:</div><div style="font-family:Helvetica,Arial;font-size:13px; "><br></div><div style="font-family:Helvetica,Arial;font-size:13px; ">FATAL: password authentication failed for user “<user>"</div><div><br></div>If I restructure the command to use the alternative postgresql:// connection string like this, then it works:<div><br></div><div>ogr2ogr --debug ON -f PostgreSQL 'postgresql://<user>:robin$42@<IP>/data?sslmode=require’ file.gpkg -nln table_name<br><div class="gmail_signature"></div></div><div class="gmail_signature"><br></div><div class="gmail_signature">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.</div><div class="gmail_signature"><br></div><div class="gmail_signature">Any suggestions welcome,</div><div class="gmail_signature"><br></div><div class="gmail_signature"><div class="gmail_signature">Best regards,</div><div class="gmail_signature"><br></div><div class="gmail_signature">Robin</div><div class="gmail_signature"><br></div><div class="gmail_signature"><br></div><div class="gmail_signature">Dr Robin Wilson</div><div class="gmail_signature"><a href="http://www.rtwilson.com">www.rtwilson.com</a></div><div class="gmail_signature"><br></div></div></body></html>