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 |
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 |