Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 941609FA173 for ; Fri, 15 Dec 2006 11:23:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 52511-01 for ; Fri, 15 Dec 2006 11:23:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ination.com (ination-69-16-151-6.phx2.puregig.net [69.16.151.6]) by postgresql.org (Postfix) with ESMTP id C36719FA0FB for ; Fri, 15 Dec 2006 11:23:23 -0400 (AST) Received: from [65.39.85.113] (account joshua.colson HELO [192.168.37.24]) by ination.com (CommuniGate Pro SMTP 5.0.9) with ESMTPSA id 2474860 for pgsql-admin@postgresql.org; Fri, 15 Dec 2006 08:23:17 -0700 Subject: Re: Change "shutdown time" was: Change "database system From: Joshua Colson To: pgsql-admin@postgresql.org In-Reply-To: <29504.1166141419@sss.pgh.pa.us> References: <1166139640.7183.27.camel@s60r.ination.com> <29504.1166141419@sss.pgh.pa.us> Content-Type: text/plain Organization: iNation, LLC Date: Fri, 15 Dec 2006 08:23:16 -0700 Message-Id: <1166196196.6761.9.camel@s60r.ination.com> Mime-Version: 1.0 X-Mailer: Evolution 2.4.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/223 X-Sequence-Number: 24015 On Thu, 2006-12-14 at 19:10 -0500, Tom Lane wrote: > 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. Well, I ended up just using the pg_control file from the running installation. The seemed to work in combination with pg_resetxlog but now the restore is not working because the postmaster has a shutdown timestamp of today's date and the recovery is thinking that it has already recovered past the proper point in time. :( Does anyone know how I can convince the postmaster to believe it was shutdown at approximately the time the pg_dumpall happened? Thank you all again for any assistance! -- Joshua Colson iNation, LLC