Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A61CF63290A for ; Mon, 1 Feb 2010 12:13:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06601-01 for ; Mon, 1 Feb 2010 16:13:01 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id E3CFF632420 for ; Mon, 1 Feb 2010 12:13:00 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id o11GCxW18335; Mon, 1 Feb 2010 11:12:59 -0500 (EST) From: Bruce Momjian Message-Id: <201002011612.o11GCxW18335@momjian.us> Subject: Re: Using pg_migrator to upgrade 8.3->8.4 In-Reply-To: To: Mark Corner Date: Mon, 1 Feb 2010 11:12:59 -0500 (EST) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/2 X-Sequence-Number: 33605 Mark Corner wrote: > We are looking to upgrade out 8.3 db to 8.4. The full dump and > restore is not very attractive due to the downtime involved. > > pg_migrator is an attractive option, but we have butted up again the > integer datetime timestamp problem: > > "Old and new pg_controldata date/time storage types do not match. > > You will need to rebuild the new server with configure > --disable-integer-datetimes or get server binaries built > with those options." Yep, that is necessary. > We also noticed that the are non id rpms available for 8.3, but we > couldn't find any for 8.4 here: > https://projects.commandprompt.com/public/pgcore No idea if anyone is building RPMs for it. The source and Win32 binaries are here: http://pgfoundry.org/frs/?group_id=1000235 > So, is the best option to compile postgres from source? Is there > anyway to change the storage of timestamps in our 8.3 db online (I am > guessing no...)? Nope. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +