Re: 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