Re: pgAgent Job never starts

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(dot)cordier(at)logixen(dot)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 <mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: Vincent CORDIER - LOGIXEN
<mailto:v(dot)cordier(at)logixen(dot)com>
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(dot)cordier(at)logixen(dot)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
<mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: Vincent CORDIER - LOGIXEN
<mailto:v(dot)cordier(at)logixen(dot)com>
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(dot)cordier(at)logixen(dot)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
<mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: Vincent CORDIER - LOGIXEN
<mailto:v(dot)cordier(at)logixen(dot)com>
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(dot)cordier(at)logixen(dot)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
<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 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(dot)cordier(at)logixen(dot)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
<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 2:41
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 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