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
