Joshua D. Drake wrote:
On Fri, 18 Apr 2008 13:54:52 -0400
Geoffrey <lists@xxxxxxxxxxxxxxxxxxxxx> wrote:
What about the:
8.1 -> slony -> 8.3
switch users to 8.3 databases
solution.
Is it? What is your transactional velocity? How long will the initial
sync transaction have to run? You know vacuum isn't working while
that transaction is open right? Are you going to have to setup up a
dozen different replicated sets in order to get it done?
Slony works in "some" cases it does not work in all nor the most
critical (in terms of large sets with minimal downtime requirement).
I don't know that slony is the answer. It was more of a question then
an answer. We are hoping to use that solution to migrate from 7.4.19 to
8.3.1. The primary reason is to reduce downtime.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin