|
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
I did it but no change...all the same
message.
----- Original Message -----
Sent: Wednesday, September 20, 2006
3:34 PM
Subject: RE: [pgadmin-support] pgAgent
Job never starts
Create one then.
Regards, Dave.
Right, but I don't have postgresql folder in
C:\Documents and
Settings\postgres\Application Data\
----- Original Message -----
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.
It's in C:\Documents and
Settings\Vincent\Application Data\postgresql
----- Original Message -----
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.
always the same message :
Couldn't create connection: fe_sendauth: no password
supplied...
----- Original Message -----
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
It's the same error message
:
"Couldn't create connection: fe_sendauth: no password
supplied" :-(
----- Original Message -----
Sent: Wednesday,
September 20, 2006 2:41 PM
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
|
