X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8EEBC3A1ABF for ; Fri, 21 Jan 2005 15:45:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32469-08 for ; Fri, 21 Jan 2005 15:45:06 +0000 (GMT) Received: from mail.grafton.lv (hornet.grafton.lv [159.148.13.2]) by svr1.postgresql.org (Postfix) with SMTP id 3EA6C3A4B90 for ; Fri, 21 Jan 2005 15:45:08 +0000 (GMT) Received: (qmail 21954 invoked from network); 21 Jan 2005 15:45:08 -0000 Received: from krisha.grafton.lv (HELO 159.148.13.13) (159.148.13.13) by hornet.grafton.lv with SMTP; 21 Jan 2005 15:45:08 -0000 Date: Fri, 21 Jan 2005 17:45:05 +0200 From: Kristaps Armanis X-Mailer: The Bat! (v1.62i) Reply-To: Kristaps Armanis Organization: Grafton Entertainment X-Priority: 3 (Normal) Message-ID: <12179534609.20050121174505@grafton.lv> To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Restoring fscked up postgres 7.1 In-Reply-To: <20050121153001.GC3749@svana.org> References: <10071638046.20050121153328@grafton.lv> <20050121153001.GC3749@svana.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.159 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200501/235 X-Sequence-Number: 16094 Friday, January 21, 2005, 5:30:07 PM, Jus rakstijat: MvO> Looks like XID wraparound, you hit the 4 billion transaction mark. This MvO> was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to MvO> recover, but this should give you something to search the archives for. Till how sorted that out already. I hyave copy of old one.. Latest checkpoint's NextXID: 2669533222 Latest checkpoint's NextOID: 26300179 Time of latest checkpoint: Fri Jan 21 16:00:48 2005 Database block size: 8192 Blocks per segment of large relation: 131072 -------------- And then it's just: Latest checkpoint's NextXID: 2747597 Latest checkpoint's NextOID: 282132 Time of latest checkpoint: Fri Jan 21 03:32:17 2005 Is there any solution? ___________________________________ Kristaps Armanis Grafton Entertainment :: IT director Brivibas Str. 214m, Riga LV1039, Latvia e-mail: krisha@grafton.lv web: http://www.tvnet.lv phn: +371 7819577 gsm: +371 9474932 fax: +371 7819578