Christian Rosnes <christian.ros...@gmail.com> writes: > Hi, > > Coming back from vacation, I find a PostgreSQL database cluster (Pg version: > 9.0.4) > with 5 databases, which for the past 5 days have logged these messages: > > ? WARNING:? oldest xmin is far in the past > ? HINT:? Close open transactions soon to avoid wraparound problems. > > The cluster has been running continously for over 9 months with autovacuum > enabled.
<snip>> > I cannot find any 'idle in transaction' connected, and I can see one 'idle' > connection > (but not 'idle in transaction') which is almost 24 hours old, the rest is > from early this morning. > See if there is a prepared transaction still open. Query pg_prepared_xacts. HTH -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 732.216.7255 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
