Re: [SL] postgresql 8.3

[<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
>