Christian Rosnes <christian.rosnes@xxxxxxxxx> 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.consulting@xxxxxxxxxxx p: 732.216.7255 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
