X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EDADDD1B1BC for ; Tue, 22 Jun 2004 17:25:28 -0300 (ADT) 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 59277-10 for ; Tue, 22 Jun 2004 20:25:25 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 50D83D1B262 for ; Tue, 22 Jun 2004 17:25:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5MKPJKf021595; Tue, 22 Jun 2004 16:25:19 -0400 (EDT) To: Richard Huxton Cc: "Shea,Dan [CIS]" , pgsql-performance@postgresql.org Subject: Re: after using pg_resetxlog, db lost In-reply-to: <40D890F3.8090208@archonet.com> References: <644D07D3D59D8F408CD01AC2F833D8C62B9209@cisxa.cmc.int.ec.gc.ca> <21115.1087932963@sss.pgh.pa.us> <40D890F3.8090208@archonet.com> Comments: In-reply-to Richard Huxton message dated "Tue, 22 Jun 2004 21:05:07 +0100" Date: Tue, 22 Jun 2004 16:25:19 -0400 Message-ID: <21594.1087935919@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/238 X-Sequence-Number: 7296 Richard Huxton writes: > Tom Lane wrote: >> This could be repaired by doing >> pg_resetxlog with a more appropriate initial transaction ID, but >> figuring out what that value should be is not easy :-( > Tom - would there be any value in adding this to a pg_dump? Possibly. CVS tip pg_dump has been changed to not output OIDs by default, as a result of gripes from people who wanted to be able to "diff" dumps from different servers and not have the diff cluttered by irrelevant OID differences. But a single header line showing current XID and OID values doesn't seem like it would be a big problem. We could put current timestamp there too, which was another recent topic of discussion. Bring it up on pghackers and see if anyone has an objection... regards, tom lane