Close open transactions soon to avoid wraparound problems

From: Brian Staszewski <brian(dot)staszewski(at)farheap(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Close open transactions soon to avoid wraparound problems
Date: 2007-09-10 18:25:01
Message-ID: 46E58BFD.80300@farheap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Vacuumdb is giving me these messages:

Vacuuming public.files...
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
VACUUM

Two questions:
1. Is there a way for me to see what application/host/user has open
transactions that need to be closed?
2. If #1 is not possible then what can I do about this?

Searching the web via normal methods only turns up indexed source code
files for vacuum.

What's been done so far:
-Cluster-wide vacuum (these are done nightly, I ran one again just for gp)
-Ran the following query looking for old/suspicious
connections/transactions, didn't find anything useful:

select procpid, datname, client_addr, usename, current_query,
query_start from pg_stat_activity order by query_start asc;

Thanks in advance,
Brian

Attachment Content-Type Size
brian.staszewski.vcf text/x-vcard 251 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2007-09-10 22:07:00 Re: reindexdb hangs
Previous Message PGallagher 2007-09-10 15:29:18 Postmaster Question