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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
