Quoth jim@nasby.net ("Jim C. Nasby"):
> On Fri, Nov 21, 2003 at 01:32:38PM -0500, Jan Wieck wrote:
>> bootstrap mode to apply the changes, could be an idea to think of. It
>> would still require some downtime, but nobody can avoid that when
>> replacing the postgres binaries anyway, so that's not a real issue. As
>> long as it eliminates dump, initdb, reload it will be acceptable.
>
> Has anyone looked at using replication as a migration method? If
> replication can be setup in such a way that you can replicate from an
> old version to a new version, you can use that to build the new version
> of the database on a seperate machine/instance while the old version is
> still live. With some sophisticated middleware, you could theoretically
> migrate without any downtime.
The idea has indeed been "looked at," and seems pretty feasible.
It would certainly take some sophisticated middleware to totally evade
downtime. But replicating from "old version" to "new version" does
have the merit of keeping the downtime to fairly much a minimum.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','cbbrowne.com').
http://www3.sympatico.ca/cbbrowne/x.html
:FATAL ERROR -- VECTOR OUT OF HILBERT SPACE