pgAgent on Windows

[Marcio Meneguzzi]

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.

PgAgent on Windows

[Marcio Meneguzzi]

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


[image: Mailtrack]

Remetente
notificado por
Mailtrack

06/11/18
11:36:31

Re: PgAgent on Windows

[Marcio Meneguzzi]

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&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
13:23:59

Em ter, 6 de nov de 2018 às 11:54, Ron  escreveu:

> 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.
>

Re: PgAgent on Windows

[Marcio Meneguzzi]

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&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
14:32:39

Em ter, 6 de nov de 2018 às 14:15, Stéphane Dunand 
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
>
>
> [image: 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
>