Bug: pgagent doesn't log SQL errors

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Bug: pgagent doesn't log SQL errors
Date: 2015-07-04 18:22:39
Message-ID: 5598246F.2080406@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Josh Berkus 2015-07-04 18:23:46 Please add timestamps to pgagent log
Previous Message Dave Page 2015-07-03 08:05:17 Re: pgagent DEB packages do not support postgres 9.4