Geoffrey wrote: > Joshua D. Drake wrote: >> On Fri, 18 Apr 2008 14:30:18 -0400 >> Geoffrey <lists@xxxxxxxxxxxxxxxxxxxxx> wrote: >> >>> 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. >> >> Well :) That is why I asked the questions I did. It very well may be >> the answer. It might not. For example, what size is your database? How >> many transactions per hour are you doing? > > We have 13 separate databases, not terribly large, my WAG would be that > our largest database might have 30 million rows. I couldn't honestly > tell you how many trans/hour we are doing without doing a little > research. I find it pretty unlikely that Slony would be unable to help you upgrade here. Obviously you can upgrade one database at a time. Also, mostly it's not the database size what's a concern, but rather the size of the largest table. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
