From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Kevin Kempter <kevin@kevinkempterllc.com>
To: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: significant vacuum issues - looking for suggestions
Date: Fri, 24 Aug 2007 15:52:20 -0500
Message-ID: <46CEFEB4.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <200708241357.23629.kevin@kevinkempterllc.com>
References: <200708241357.23629.kevin@kevinkempterllc.com>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, kevin@kevinkempterllc.com
Subject: Re: significant vacuum issues - looking for suggestions
In-Reply-To: <46CEFEB4.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox