I am running pgAgent on Debian Sarge with postgresql 8.1.4. I have run
the SQLscript and installed the tables. I have run the daemon with the
command: /usr/bin/pgagent hostaddr=127.0.0.1 dbname=postgres user postgres
I have also tried the command: /usr/bin/pgagent hostaddr=127.0.0.1 dbname=ec user postgres
ec is the name of my data database. The pgAgent tables have been
installed in both databases duriing my attempts to get it working.
I am getting the following error in the postgresql log everytime (every
30 seconds) pgAgent runs depending on which command I used to start
pgAgent:
2006-08-01 21:24:28.785 EDT postgres ec LOG: could not receive data
from client: Connection reset by peer
2006-08-01 21:24:38.259 EDT postgres postgres LOG: could not receive
data from client: Connection reset by peer
I am running pgAdmin III on Windows and I have configured and scheduled
a test job. The job indicates that it has never run and it is not
currenlty running.
Any assistance would be appreciated.
Chuck