From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | "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 21:08:13 |
Message-ID: | 20070824170813.72c0f39e.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
In response to "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> >>> 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.
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/
wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-24 21:39:22 | Re: significant vacuum issues - looking for suggestions |
Previous Message | Kevin Grittner | 2007-08-24 20:52:20 | Re: significant vacuum issues - looking for suggestions |