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
