DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=roeurMxgYOYXEKbRvIkAergEDX2VqCR4O4hgkcLIg5GULHNb4Sd538q/5wrufpzpGy
	Xlm2wAazugQEXhPWm9+Pdqu4Zz9itjWN9eN0CxpAf2tiEBoEyX8+WLhYxaDHCc/72VkZ
	kVQqRWGv6jKr53obDatnGwNv1/0SFCGp+5eLM=
Subject: Re: Using pg_migrator to upgrade 8.3->8.4
Mime-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
From: Mark Corner <mcorner@gmail.com>
In-Reply-To: <201002011612.o11GCxW18335@momjian.us>
Date: Mon, 1 Feb 2010 11:24:43 -0500
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <E2FA0475-78D3-4C5E-88F3-6E3DAB8B0A42@gmail.com>
References: <201002011612.o11GCxW18335@momjian.us>
To: Bruce Momjian <bruce@momjian.us>

All good info...

With respect to RPMs, I was actually referring to postgres84 rpms with =
non-integer datetime prebuilt.

On Feb 1, 2010, at 11:12 AM, Bruce Momjian wrote:

> 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.
>>=20
>> pg_migrator is an attractive option, but we have butted up again the
>> integer datetime timestamp problem:
>>=20
>> "Old and new pg_controldata date/time storage types do not match.
>>=20
>> You will need to rebuild the new server with configure
>> --disable-integer-datetimes or get server binaries built
>> with those options."
>=20
> Yep, that is necessary.
>=20
>> 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
>=20
>=20
> No idea if anyone is building RPMs for it.  The source and Win32
> binaries are here:
>=20
> 	http://pgfoundry.org/frs/?group_id=3D1000235
>=20
>> 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...)?
>=20
> Nope.
>=20
> --=20
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>=20
>  + If your life is a hard drive, Christ can be your backup. +