All, We recently dealt with a site where, do to mistakes in migrating servers, the sequences for pgagent got reset to 1. This caused primary key conflicts which caused pgagent to fail. However, no failures of any kind appeared in the pgagent log, even though PK violation errors were appearing in the Postgres log.
-- 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