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). Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
