PostgreSQL 11 running on
Windows 2012 server, I created a job with
In the step, in
connection string I used the
password parameter and it works.
Instead, I would like to use
passfile parameter with a pgpass.conf, located in
C:\Users\POSTGIS\AppData\Roaming\postgresql\according to the doc
I tried many ways ton write the passfile unsuccessfully. For example I wrote :
host=localhost port=5432 user=POSTGIS passfile=C:\\Users\\POSTGIS\\AppData\\Roaming\\postgresql\\pgpass.conf dbname=xxxx
...with single or double backslashs or slashs.
But I always have a
Please enter a valid connection string message.
I am out of ideas.