In response to "Kevin Grittner" <[EMAIL PROTECTED]>:

> >>> On Fri, Aug 24, 2007 at  2:57 PM, in message
> <[EMAIL PROTECTED]>, Kevin Kempter
> <[EMAIL PROTECTED]> wrote: 
> >    c) setup WAL archiving on the 8.1.4 cluster
> > 
> >    d) do a full dump of the 8.1.4 cluster and restore it to the new 8.2.4 
> > cluster
> > 
> >    e) stop the 8.2.4 cluster and bring it up in recovery mode, pointing it 
> > to 
> > the directory where we're archiving the 8.1.4 cluster's WAL segments.
> 
> You can't use these techniques for a major version upgrade.
> Use pg_dump piped to psql.  That will also eliminate all bloat.

If you can't afford any downtime, you may be able to use Slony to
do your upgrade.  However, slony adds overhead, and if this system
is tapped out already, it may not tolerate the additional overhead.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

[EMAIL PROTECTED]
Phone: 412-422-3463x4023


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to