Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 33FA19F9D22 for ; Mon, 10 Sep 2007 15:57:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 61270-03 for ; Mon, 10 Sep 2007 15:57:47 -0300 (ADT) X-Greylist: delayed 00:32:41.97743 by SQLgrey-1.7.5 Received: from ldapmta.farheap.com (zsmtp.farheap.com [64.22.136.34]) by postgresql.org (Postfix) with ESMTP id 797069F9A71 for ; Mon, 10 Sep 2007 15:57:47 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ldapmta.farheap.com (Postfix) with ESMTP id 0F8C534C031 for ; Mon, 10 Sep 2007 11:21:16 -0700 (PDT) X-Virus-Scanned: amavisd-new at Received: from ldapmta.farheap.com ([127.0.0.1]) by localhost (ldapmta.farheap.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QNMrnZw8GTAj for ; Mon, 10 Sep 2007 11:21:13 -0700 (PDT) Received: from [10.1.129.88] (daimler.farheap.net [66.238.64.20]) by ldapmta.farheap.com (Postfix) with ESMTP id B01C234C4A5 for ; Mon, 10 Sep 2007 11:21:13 -0700 (PDT) Message-ID: <46E58BFD.80300@farheap.com> Date: Mon, 10 Sep 2007 11:25:01 -0700 From: Brian Staszewski User-Agent: Thunderbird 2.0.0.6 (X11/20070808) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Close open transactions soon to avoid wraparound problems Content-Type: multipart/mixed; boundary="------------090809020700030402070502" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200709/54 X-Sequence-Number: 26815 This is a multi-part message in MIME format. --------------090809020700030402070502 Content-Type: multipart/alternative; boundary="------------070401070802060306040503" --------------070401070802060306040503 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------070401070802060306040503 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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
--------------070401070802060306040503-- --------------090809020700030402070502 Content-Type: text/x-vcard; charset=utf-8; name="brian.staszewski.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="brian.staszewski.vcf" begin:vcard fn:Brian Staszewski n:Staszewski;Brian org:Farheap Solutions, Inc.;Information Technologies email;internet:brian.staszewski@farheap.com title:Systems Administrator tel;work:(949) 417-1500 x948278 x-mozilla-html:TRUE version:2.1 end:vcard --------------090809020700030402070502--