Re: PgAgent on Windows - Mailing list pgsql-general

From Stéphane Dunand
Subject Re: PgAgent on Windows
Date
Msg-id 15af0a56-93c8-86ec-541c-86ade27ddf1b@sirap.fr
Whole thread Raw
In response to PgAgent on Windows  (Marcio Meneguzzi <marcio.meneguzzi@gmail.com>)
Responses Re: PgAgent on Windows
List pgsql-general
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 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

pgsql-general by date:

Previous
From: Marcio Meneguzzi
Date:
Subject: Re: PgAgent on Windows
Next
From: "Daniel Verite"
Date:
Subject: Re: Trouble Upgrading Postgres