Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 40731632793 for ; Sun, 18 Apr 2010 00:21:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57451-02 for ; Sun, 18 Apr 2010 03:21:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from imail.internode.com.au (exchht01-ext.internode.com.au [203.26.95.185]) by mail.postgresql.org (Postfix) with ESMTP id 152DB6326F5 for ; Sun, 18 Apr 2010 00:21:22 -0300 (ADT) Received: from EXCHMAIL.staff.internode.com.au ([169.254.2.211]) by exchht01.staff.internode.com.au ([fe80::193f:3ff6:d38f:74dc%12]) with mapi; Sun, 18 Apr 2010 12:51:18 +0930 From: Samuel Stearns To: Kevin Grittner CC: "pgsql-admin@postgresql.org" Date: Sun, 18 Apr 2010 12:51:18 +0930 Subject: Re: FW: More than 1 pg_database Entry for Database - Thread #2 Thread-Topic: [ADMIN] FW: More than 1 pg_database Entry for Database - Thread #2 Thread-Index: Acrdfqvnmipr9Q/OQAKpow8GZI94xgBJ1+gg Message-ID: <68B59BEDCD36854AADBDF17E91B2937AB89DE9D4@EXCHMAIL.staff.internode.com.au> References: <68B59BEDCD36854AADBDF17E91B2937AB89DE7F7@EXCHMAIL.staff.internode.com.au> <4BC8447C02000025000309EA@gw.wicourts.gov> In-Reply-To: <4BC8447C02000025000309EA@gw.wicourts.gov> Accept-Language: en-US, en-AU Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US, en-AU Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/245 X-Sequence-Number: 34339 Thanks very much for the advice, Kevin. I'll be raising a request with our= sysadmins to upgrade to 8.3.10. Sam -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]=20 Sent: Saturday, 17 April 2010 1:36 AM To: Samuel Stearns Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] FW: More than 1 pg_database Entry for Database - Threa= d #2 Samuel Stearns wrote: =20 > I am running version 8.3.3 and encountered a problem =20 > Does anyone have any ideas how I can keep from getting into this > duplicate database scenario? Any advice would be greatly > appreciated. =20 > it was stated by Tom Lane that the large xmax number may indicate > a problem with xid wraparound and that the problem row was never > vacuumed away due to broken vacuuming procedures. =20 Applying the last 22 months of bug fixes would be a good start. =20 http://www.postgresql.org/support/versioning =20 http://www.postgresql.org/docs/8.3/static/release.html =20 http://www.postgresql.org/download/ =20 Autovacuum is supposed to protect you from wraparound, so it appears to have fallen down somehow. There were fixes for autovacuum bugs in 8.3.4 and 8.3.6, so it's entirely possible that just moving to 8.3.somethingrecent will prevent a recurrence. =20 -Kevin