Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAgent Job never starts - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAgent Job never starts
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40176CEFB@ratbert.vale-housing.co.uk
Whole thread Raw
In response to pgAgent Job never starts  ("Vincent CORDIER - LOGIXEN" <v.cordier@logixen.com>)
List pgadmin-support
Tree view
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.cordier@logixen.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
Sent: Wednesday, September 20, 2006 12:03 PM
Subject: Re: [pgadmin-support] pgAgent Job never starts

 

From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.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.

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: bug report
Next
From: "Dave Page"
Date:
Subject: Re: pgAgent Job never starts