Thread: pgAgent on Windows
Hi,
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
#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}
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