Re: pgAgent Job never starts

Because pgAgent must connect to the database where the jobs are defined
as well as whichever ones you are running jobs in.

Regards, Dave

________________________________

From: Vincent CORDIER - LOGIXEN [mailto:v(dot)cordier(at)logixen(dot)com]
Sent: 20 September 2006 12:54
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts


What ? I don't understand...sorry

----- Original Message -----
From: Dave Page <mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: Vincent CORDIER - LOGIXEN
<mailto:v(dot)cordier(at)logixen(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Sent: Wednesday, September 20, 2006 12:03 PM
Subject: Re: [pgadmin-support] pgAgent Job never starts

________________________________

From: Vincent CORDIER - LOGIXEN
[mailto:v(dot)cordier(at)logixen(dot)com]
Sent: 20 September 2006 10:39
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never
starts


Hello,

I created a connection string like that
"localhost:5432:marketing:postgres:zryt678" in
%APPDATA%\postgresql\pgpass.conf

but that dosen't work I have in my log file this
message :

"Couldn't create connection: fe_sendauth: no
password supplied"

thank you

Perhaps you need a similar entry for the database in
which the pgAgent configuration data is stored? (probably the postgres
database).

Regards, Dave.