Re: 9.1 to 9.2 requires a dump/reload?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: Nikolas Everett <nik9000(at)gmail(dot)com>
Cc: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.1 to 9.2 requires a dump/reload?
Date: 2012-10-22 22:02:13
Message-ID: CAP=oouFps-WP2jizSv+UVEeM04ZqZ7E2hw7L5y-dcUEvHCOWwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pg_upgrade has worked fine for several releases. I believe that the
only time when pg_upgrade isn't a viable option is for some types of
GIST indices.

On Mon, Oct 22, 2012 at 2:55 PM, Nikolas Everett <nik9000(at)gmail(dot)com> wrote:
> I was just looking at
> http://www.postgresql.org/docs/devel/static/release-9-2.html and it
> mentioned that a dump/reload cycle was required to upgrade from a previous
> release. I just got done telling some of my coworkers that PG had been
> bitten by this enough times that they were done with it. Am I wrong? Is
> this normal?
>
> I see that pg_upgrade is an option. Having never used how long should I
> expect pg_upgrade to take? Obviously we'll measure it in our environment,
> but it'd be nice to have a ballpark figure.
>
> Nik

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand https://netllama.linux-sxs.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2012-10-22 22:17:19 Re: 9.1 to 9.2 requires a dump/reload?
Previous Message Nikolas Everett 2012-10-22 21:55:07 9.1 to 9.2 requires a dump/reload?