Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 84C109FA1FD for ; Thu, 14 Dec 2006 20:10:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 22676-07 for ; Thu, 14 Dec 2006 20:10:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A2BF99FA173 for ; Thu, 14 Dec 2006 20:10:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBF0AJQm029505; Thu, 14 Dec 2006 19:10:19 -0500 (EST) To: Joshua Colson cc: pgsql-admin@postgresql.org Subject: Re: Change "database system identifier" in pg_control? In-reply-to: <1166139640.7183.27.camel@s60r.ination.com> References: <1166139640.7183.27.camel@s60r.ination.com> Comments: In-reply-to Joshua Colson message dated "Thu, 14 Dec 2006 16:40:40 -0700" Date: Thu, 14 Dec 2006 19:10:19 -0500 Message-ID: <29504.1166141419@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/207 X-Sequence-Number: 23999 Joshua Colson writes: > So I thought I would try to change the SYSID to 4965793265546637307 and > have another shot at it. > I'm not a PG guru so please let me know, is there any chance that what > I'm doing will be successful, or am I just wasting my time? You'd have to modify pg_resetxlog to force that value into the sysid rather than whatever is there. Hand-editing wouldn't work very well because of (a) the CRC on pg_control and (b) the need to copy the value into extant WAL segments. regards, tom lane