Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4D8399FA2CA for ; Fri, 15 Dec 2006 14:07:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 76275-04 for ; Fri, 15 Dec 2006 14:07:47 -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 719C29F9398 for ; Fri, 15 Dec 2006 14:07:47 -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 2475876 for pgsql-admin@postgresql.org; Fri, 15 Dec 2006 11:07:46 -0700 Subject: Re: Change "shutdown time" was: Change "database system From: Joshua Colson To: pgsql-admin@postgresql.org In-Reply-To: <12366.1166205424@sss.pgh.pa.us> References: <1166139640.7183.27.camel@s60r.ination.com> <29504.1166141419@sss.pgh.pa.us> <1166196196.6761.9.camel@s60r.ination.com> <12366.1166205424@sss.pgh.pa.us> Content-Type: text/plain Organization: iNation, LLC Date: Fri, 15 Dec 2006 11:07:46 -0700 Message-Id: <1166206066.6761.14.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/230 X-Sequence-Number: 24022 On Fri, 2006-12-15 at 12:57 -0500, Tom Lane wrote: > The problem with that is that it'll have a fairly current > last-checkpoint pointer. You really need a last-checkpoint pointer > pointing at where the rollforward needs to start. Can't I just reset the last-checkpoint pointer using pg_resetxlog, or will it not do that? Thanks. -- Joshua Colson iNation, LLC