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@gmail.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@gmail.com
LlamaLand https://netllama.linux-sxs.org