Re: PgAgent on Windows

Le 06/11/2018 à 14:36, Marcio Meneguzzi a écrit :

Hello,

I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.

My version of PostgreSQL is 9.5.1.14

Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:

"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"

My %APPDATA%\postgresql\pg_pass.conf is:

localhost:5490:*:postgres:my_pass

Please, any help?

Thank´s,

Márcio

Remetente notificado por Mailtrack 06/11/18 11:36:31

Hello,

check
1) the user account who launch pgagent service. %appdata% is relative to this user
2) pg_pass.conf must be in folder %appdata%\roaming\postgresql
3) host parameter in pgagent service command line must match hostname in pg_pass.conf

Stéphane