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

From Dave Page
Subject Re: pgAgent Job never starts
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40176CF13@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
So to recap:
 
- You have a pgpass.conf file in C:\Documents and Settings\postgres\Application Data\postgresql
 
- It has entries for:
 
127.0.0.1:5432:solofamily:postgres:XXXXXX
127.0.0.1:5432:postgres:postgres:XXXXX
localhost:5432:solofamily:postgres:XXXXXX
localhost:5432:postgres:postgres:XXXXX
 
- The pgAgent schema is in the postgres database.
 
- The job step runs in the solofamily database.
 
- pgAgent is running as a service, and was installed with the command:
 
"D:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -l 2 -u postgres -p XXXXX hostaddr=127.0.0.1 dbname=postgres user=postgres
 
I cannot think of anything else that would cause this error assuming all the above is correct. Can you confirm that for me please, and that you have restarted pgAgent?
 
Regards, Dave


From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 14:36
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

I did it but no change...all the same message.
----- Original Message -----
From: Dave Page
Sent: Wednesday, September 20, 2006 3:34 PM
Subject: RE: [pgadmin-support] pgAgent Job never starts

Create one then.
 
Regards, Dave.


From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 14:26
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

Right, but I don't have postgresql folder in C:\Documents and Settings\postgres\Application Data\
----- Original Message -----
From: Dave Page
Sent: Wednesday, September 20, 2006 3:25 PM
Subject: RE: [pgadmin-support] pgAgent Job never starts

Right, but pgAgent runs under the postgres account, so it should be in:
 
C:\Documents and Settings\postgres\Application Data\postgresql
 
Regards, Dave.

From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 14:13
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

It's in C:\Documents and Settings\Vincent\Application Data\postgresql
----- Original Message -----
From: Dave Page
Sent: Wednesday, September 20, 2006 3:10 PM
Subject: RE: [pgadmin-support] pgAgent Job never starts

Where is your pgpass.conf file? Are you sure it's in the postgres user's profile and not yours?
 
Regards Dave.


From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 14:05
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

always the same message :

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

----- Original Message -----
From: Dave Page
Sent: Wednesday, September 20, 2006 2:58 PM
Subject: RE: [pgadmin-support] pgAgent Job never starts

Oh, sorry - spotted something else - 127.0.0.1 is not the same as localhost as far as pgpass.conf is concerned. The easiest test is pribably to add the following to the pgpass.conf:

127.0.0.1:5432:solofamily:postgres:XXXXXX

127.0.0.1:5432:postgres:postgres:XXXXX
 
In production though, I would standardise your pgAgent config and everything else to use one or the other.
 
Regards, Dave
 


From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 13:51
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

It's the same error message :

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

----- Original Message -----
From: Dave Page
Sent: Wednesday, September 20, 2006 2:41 PM
Subject: Re: [pgadmin-support] pgAgent Job never starts

 


From: Vincent CORDIER - LOGIXEN [mailto:v.cordier@logixen.com]
Sent: 20 September 2006 15:08
To: Dave Page
Subject: Re: [pgadmin-support] pgAgent Job never starts

Here is the the pgAgent command line :
 
"D:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -l 2 -u postgres -p XXXXX
 
hostaddr=127.0.0.1 dbname=postgres user=postgres
 
and the pgpass.conf file  
 
OK, this modified pgpass.conf should do the job:
 
# This entry is required to connect and run the job step
localhost:5432:solofamily:postgres:XXXXXX
 
# This entry is required to access the pgAgent configuration
localhost:5432:postgres:postgres:XXXXX
 
Install that, restart pgAgent and the errors in the event log should vanish and the job should run.
 
Regards, Dave 

pgadmin-support by date:

Previous
From: Sim Zacks
Date:
Subject: bug report
Next
From: "Nagita Karunaratne"
Date:
Subject: Re: pgAgent Job never starts