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@xxxxxxxxx> 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@xxxxxxxxx LlamaLand https://netllama.linux-sxs.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general