Re: [SL] postgresql 8.3

[Michael H. <mh...@it...>]

And backups!  Lots of backups - at every step!  :)


Thanks,

Michael


On Jul 23, 2008, at 10:04 AM, Paul Tammes wrote:

> I remember seeing something in the release notes regarding 'fix  
> behaviour in
> postgresql 8.3.
> So I suggest to first upgrade Ledger, then upgrade postgres. No  
> need to
> invite known bugs to the party, right?
>
> 2008/7/23 <la...@cl...>:
>
>> Hello David:
>>
>> Back in May we had upgraded our production system from
>> RH7.3/Postgresql7.x/SL2.4 to Centos5.2/Postgresql8.3.1(now at
>> 8.3.3)/SL2.8.14(now at 2.8.16). Everything worked out nicely and  
>> it's been
>> couple months now (with two proven monthends). The main thing was  
>> please
>> make sure to use the newer 8.3 tools to do the dump, and to use  
>> the same
>> database encoding for the upgrade.
>>
>> Some extra info. when we upgraded Postgres from 8.3.1 to 8.3.3 it  
>> was just
>> a simply binary upgrade without the need to touch the data. We  
>> also had
>> rolled out slony replication on the production cluster and production
>> issues had yet to creep up, but we also had only replicated tables  
>> that
>> were relevant to the IC module.
>>
>> You should be alright with the 8.1 -> 8.3 upgrade.
>>
>> Regards,
>>
>> Tim
>>
>>
>>
>>> I'm thinking of migrating sql-ledger from 2.6.27 / postgresql 8.1 to
>>> 2.8.16 / postgresql 8.3
>>>
>>> Are there any migration issues during the transition? In other  
>>> words,
>>> will the pg-dump from SL 2.6.27 / pg 8.1 talk nicely to pg 8.3?  
>>> Or do I
>>> have to upgrade via pg 8.1, and the go to pg 8.3 at the last step?
>>>
>>> thanks
>>>
>>>
>>> David.
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> -----
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>> challenge
>>> Build the coolest Linux based applications with Moblin SDK & win  
>>> great
>>> prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in  
>>> the
>>> world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win  
>> great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in  
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users