I can't to put the pgAgent service using parameter postgres to (Windows username) and (database username) without to use the password parameter inside the connection string (hostaddr=127.0.0.1 dbname=postgres user=postgres password=ourPassword).
If I put Windows user and postgres to database user, no problem: the pgpass.conf is read.
But, if I use (-u postgres) as a Windows user too (like the postgreSQL service), I think that pgAgent does not read the pgpass.conf. I tried to use the variable PGPASSFILE without success.
Any sugestions?
Thank you,
Josi Perez
