Re: PgAgent on Windows

From: Marcio Meneguzzi <marcio(dot)meneguzzi(at)gmail(dot)com>
To: s(dot)dunand(at)sirap(dot)fr
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PgAgent on Windows
Date: 2018-11-06 16:33:32
Message-ID: CAOWx7Xq2Oge7HauteqhjM92UVW8BjazmG2WeP84r5UzGO_edeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <s(dot)dunand(at)sirap(dot)fr>
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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-11-06 17:00:35 Re: Trouble Upgrading Postgres
Previous Message Daniel Verite 2018-11-06 16:27:57 Re: Trouble Upgrading Postgres