Hello
Can you remember where did you read that? There is no mention of GIST on
http://www.postgresql.org/docs/9.2/static/upgrading.html and a database
which uses GIST indexes *seems* to work just finde after upgrading with
pg_upgrade.
bye,
-christian-
Am Mon, 22 Oct 2012 15:02:13 -0700
schrieb Lonni J Friedman <netllama@gmail.com>:
> 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
>
>
>