PGPASS password file

[Patrick Irvin]

I propose supporting the PG Password file as described here: https://www.postgresql.org/docs/current/libpq-pgpass.html

1. if “Connections Strings” is empty, try to read from file:

2. if file does not exist, show user dialog:

‌

[Antoine Chalons]

thanks for reporting this, I’ll take a look.

[Patrick Irvin]

@Antoine you can see my code here. It is based on your most recent commit in the dev branch. I needed to back save to LV 2016, but I don’t think there should be any issues opening in 2017. I tried to add a default pgpass path that will work on RT Linux but I am unable to confirm if it will work.

[Patrick Irvin]

Antoine, This issue is a misunderstanding on my part. It is not our job to parse the PGPASS file, that is up to libpq. Given a connection string with host= port= database= user=, libpq will then look into the PGPASS file to find the appropriate password. The PGPASS file can store multiple lines with different hostname:port:database:username:password

I propose that this issue is closed. Or converted to one to improve the documentation