PgAgent on Windows

On 11/06/2018 07:36 AM, Marcio Meneguzzi wrote:

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

06/11/18 11:36:31

What do you mean by "run a job"?  Can you interactively log in?

--
Angular momentum makes the world go 'round.

Run a Job is:
In PgAdminit´s right click over the name of job and select option "Run Now".
After, when i open windows log aplication´s, a message like this "*"Couldn't
create the primary connection (attempt 1): fe_sendauth: no password
supplied" is generated.*
*Thank´s.*

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&amp;utm_medium=signature&amp;utm_campaign=signaturevirality5&amp;&gt;
Remetente
notificado por
Mailtrack
<https://mailtrack.io?utm_source=gmail&amp;utm_medium=signature&amp;utm_campaign=signaturevirality5&amp;&gt;
06/11/18
13:23:59

Em ter, 6 de nov de 2018 às 11:54, Ron <ronljohnsonjr@gmail.com> 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

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

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.

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&amp;utm_medium=signature&amp;utm_campaign=signaturevirality5&amp;&gt;
Remetente
notificado por
Mailtrack
<https://mailtrack.io?utm_source=gmail&amp;utm_medium=signature&amp;utm_campaign=signaturevirality5&amp;&gt;
06/11/18
14:32:39

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