Re: PgAgent on Windows

[Marcio Meneguzzi <marcio.meneguzzi@xxxxxxxxx>]

Thank´s Stéphane,

My pg_pass.conf in database_name parameter was postgres, but when I change for *, then run successful.

Thank´s again,

Márcio.

Remetente notificado por Mailtrack 06/11/18 14:32:39

Em ter, 6 de nov de 2018 às 14:15, Stéphane Dunand <s.dunand@xxxxxxxx> escreveu:

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