Re: significant vacuum issues - looking for suggestions - Mailing list pgsql-performance

>>> On Fri, Aug 24, 2007 at  2:57 PM, in message
<200708241357.23629.kevin@kevinkempterllc.com>, Kevin Kempter
<kevin@kevinkempterllc.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