Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E34A79FB5E2 for ; Thu, 9 Aug 2007 06:37:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74214-03 for ; Thu, 9 Aug 2007 06:36:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fmmailgate04.web.de (fmmailgate04.web.de [217.72.192.242]) by postgresql.org (Postfix) with ESMTP id 6B2389FB42D for ; Thu, 9 Aug 2007 06:37:01 -0300 (ADT) Received: from web.de by fmmailgate04.web.de (Postfix) with SMTP id A32C72D53314; Thu, 9 Aug 2007 11:36:59 +0200 (CEST) Received: from [217.86.138.6] by freemailng0201.web.de with HTTP; Thu, 09 Aug 2007 11:36:59 +0200 Date: Thu, 09 Aug 2007 11:36:59 +0200 Message-Id: <2043801453@web.de> MIME-Version: 1.0 From: pingu.freak@web.de To: Nick Fankhauser , Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Specific questions about wraparound and vacuum Precedence: fm-user Organization: http://freemail.web.de/ X-Provags-Id: V01U2FsdGVkX19mFJSS1rJ+8U3784lDva2AFxPs5QWxfduxZvuViFs5699cQ uEpVKGSwFds6v0bdiSVEOHywsZt16QfdxxiOEP4xXEhkoDoQQbL2NY0VG8iZ w== Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.83 tagged_above=0 required=5 tests=AWL=0.433, BAYES_50=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: * X-Archive-Number: 200708/99 X-Sequence-Number: 26430 Hi, thanks alot for your answers. Yesterday I have updated the kernel. After a reboot, the ECC-Kernel error = still appears. Then I've cleaned the RAM-Slots with nose-paper :), rebooted the machine, and the error was = away! Unbelievable, the error was before on both the machines. Yesterday night, i've switched my Slony-replication and the IP address. Ri= ght now, thanks to god, I'm on a safe side. :) Now i will clean the old production machine :) and putting it back to the = replication. :) Over again, thanks very much, I like PostgreSQL and the Community, it's a = very very good project :)! Regards, Martin -----Urspr=FCngliche Nachricht----- Von: Tom Lane Gesendet: 08.08.07 18:36:09 An: "Nick Fankhauser" CC: pgsql-admin@postgresql.org Betreff: Re: [ADMIN] Specific questions about wraparound and vacuum=20 "Nick Fankhauser" writes: > 1) Do we need to do a *full* vacuum or just a "lazy" vacuum to take care= of > the xid wraparound issues=3F Lazy is sufficient --- as long as it's database-wide including the system catalogs (which means a superuser has to do it). > Or... is it the case that by one billion, the docs really mean 2^30 > (1073741824) =3F 2^30. You appear to have executed a bit under 600000 transactions since vacuuming, so if that's three hours then you've got about 5000 hours until wraparound. > 4) The documentation implies that I need to vacuum *every* database, eve= n if > I'm not using them all, so I vacuumed template1, but can't connect to > template0. Do I really need to vacuum databases where no transactions ar= e > occurring=3F If so, how to I deal with template0=3F You don't need to touch frozen databases. This was discussed yesterday ..= . regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ=3F http://www.postgresql.org/docs/faq =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Jetzt neu! Sch=FCtzen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate kostenlos testen. http://www.pc-sicherheit.web.de/startseite/=3Fmc=3D022220