>>> 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. -Kevin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster