>>> On Fri, Aug 24, 2007 at 2:57 PM, in message
<200708241357(dot)23629(dot)kevin(at)kevinkempterllc(dot)com>, Kevin Kempter
<kevin(at)kevinkempterllc(dot)com> 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