| 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: | Whole Thread | Raw Message | 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 |