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
>
>
> Mailtrack
> <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
> Remetente notificado por
> Mailtrack
> <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
> 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