All,
On the same server with the SQL errors (sequences are cleaned up now),
we're having pgagent start all jobs in the "r" state, log the first step
in each job in the "r" state, and then hang forever (or, at least for
three days). At this point, 8 different jobs are in "r" state.
In pg_stat_activity, pgagent is connected, but hasn't run anything
except the query to get the next step.
We're debugging away, but would appreciate advice on other ways to
figure out what pgagent is doing.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com