From: Paul T. <pt...@wa...> - 2008-07-23 17:04:57
|
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 > > |