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 7547E3A4B9E; Fri, 21 Jan 2005 15:30:29 +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 28553-10; Fri, 21 Jan 2005 15:30:15 +0000 (GMT) Received: from svana.org (svana.org [203.20.62.76]) by svr1.postgresql.org (Postfix) with ESMTP id 09C643A4B90; Fri, 21 Jan 2005 15:30:18 +0000 (GMT) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 1Cs0jf-0002tv-00; Sat, 22 Jan 2005 02:30:07 +1100 Date: Fri, 21 Jan 2005 16:30:07 +0100 From: Martijn van Oosterhout To: Kristaps Armanis Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Restoring fscked up postgres 7.1 Message-ID: <20050121153001.GC3749@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Kristaps Armanis , pgsql-admin@postgresql.org, pgsql-general@postgresql.org References: <10071638046.20050121153328@grafton.lv> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="uh9ZiVrAOUUm9fzH" Content-Disposition: inline In-Reply-To: <10071638046.20050121153328@grafton.lv> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/233 X-Sequence-Number: 16092 --uh9ZiVrAOUUm9fzH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 21, 2005 at 03:33:28PM +0200, Kristaps Armanis wrote: > Last night no crash, not anything, just @ one moment all records for > last year where gone, all ros created for last year & tables created > while this time - and not in only one database, but all 6 DB's on this > server. Looks like XID wraparound, you hit the 4 billion transaction mark. This was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to recover, but this should give you something to search the archives for. Hope this helps, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. --uh9ZiVrAOUUm9fzH Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFB8R/5Y5Twig3Ge+YRAobRAJ4jc7QLO3QVW3cVlqNRADZ9v4NUqwCdH77D Xrb7tqrWbs9U0g58m32DZLw= =qwGw -----END PGP SIGNATURE----- --uh9ZiVrAOUUm9fzH--