Re: significant vacuum issues - looking for suggestions

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Kevin Kempter" <kevin(at)kevinkempterllc(dot)com>, "Pgsql performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: significant vacuum issues - looking for suggestions
Date: 2007-08-24 20:52:20
Message-ID: 46CEFEB4.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-08-24 21:08:13 Re: significant vacuum issues - looking for suggestions
Previous Message Bill Moran 2007-08-24 20:41:44 Re: significant vacuum issues - looking for suggestions