Re: Using pg_migrator to upgrade 8.3->8.4

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.
>>
>> 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  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +