Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 31B149FBDF1 for ; Thu, 1 Mar 2007 10:59:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 85521-07-2 for ; Thu, 1 Mar 2007 10:59:01 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web53512.mail.yahoo.com (web53512.mail.yahoo.com [206.190.39.66]) by postgresql.org (Postfix) with SMTP id 356B89FBE29 for ; Thu, 1 Mar 2007 10:59:07 -0400 (AST) Received: (qmail 48105 invoked by uid 60001); 1 Mar 2007 14:59:05 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=IV1xhGt5UeQ3w3zKxM3mDkxmaJuraxOkCVpXHodsGCBrSE3KTu0XzPw1jtgq45/bhFaz6Y05agMFYOTApozRTBBuA1tYkCVGcbDIkkP5fFGNfynTHI2R27HJwCsd5ssMQnjKgNWzvUAMLz4m4lHL12h1RT5N1X+vRuGjMhhGLoM=; X-YMail-OSG: qdMQNkoVM1kfjrHOV_3ztLrKcEz6sNqsfBXnceazUrKg10C0wrqDjP6wx6v.nEt2iIhTiYAiEr.V64IJDzskZQm.lcVueiZwJY5vUfwv9R1HS4ADRn6KKcRst57ERa6AwYJPaj_Ztr.vsjA- Received: from [209.87.238.132] by web53512.mail.yahoo.com via HTTP; Thu, 01 Mar 2007 06:59:05 PST X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8 Date: Thu, 1 Mar 2007 06:59:04 -0800 (PST) From: jing han Subject: postgres 8.1.8 transaction ID wrapper around related problem To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-ID: <349058.47955.qm@web53512.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.742 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FROM_HAS_ULINE_NUMS X-Spam-Level: ** X-Archive-Number: 200703/1 X-Sequence-Number: 6442 Hello,=0A=0AI have a transaction ID wrapper around related problem:=0A=0ADo= es vacuum freeze only need to be done when initdb? is it a one time thing, = only do it once??? no more??=0A=0Ain my system, when I use=0A=0Aselect datn= ame, age(datfrozenxid) from pg_database;=0A=0AI get the following data:=0A= =0Adatname age=0Apostgres 2075973034=0Anetman = 2117293144=0Atemplate1 1795797763=0Atemplate0 2075973034=0A=0AI'= m worried about the age for template0, I would think when initdb, template0= has already been vacuum freezed,=0Athe datallowconn for template0 is set t= o false, we cannot connect template0. If the age for template0 keep going u= p,=0Awill it meet transaction ID wrapper around problem??? Is one more vac= uum freeze on template0 needed???=0A=0A=0Ajing=0A=0A=0A=0A=0A =0A__________= __________________________________________________________________________= =0ADon't pick lemons.=0ASee all the new 2007 cars at Yahoo! Autos.=0Ahttp:/= /autos.yahoo.com/new_cars.html