From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Vincent CORDIER - LOGIXEN" <v(dot)cordier(at)logixen(dot)com> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAgent Job never starts |
Date: | 2006-09-20 12:58:38 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176CF06@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-09-20 13:48:55 | Re: pgAgent Job never starts |
Previous Message | Dave Page | 2006-09-20 12:41:16 | Re: pgAgent Job never starts |