Re: pg_upgrade across more than two neighboring major releases

On Tue, Jul 23, 2013 at 09:48:16PM +0900, Michael Paquier wrote:
>
>
>
> On Tue, Jul 23, 2013 at 8:53 PM, Pavel Raiskup <praiskup(at)redhat(dot)com> wrote:
>
> Is pg_upgrade supposed to work even across multiple major releases? (I
> know
> that the README.rpm-dist is mentioning just one major release step, but it
> could be bound just to actual pg_upgrade which is packaged..)
>
> Yes you should be able to do a one-step upgrade as long as you update from at
> least a 8.3 server. There are some restrictions depending on the server version
> that is going to be upgraded though, you can have a look at the documentation
> for more details here:
> http://www.postgresql.org/docs/9.2/static/pgupgrade.html

Yes, you can easily skip many major versions in on pg_upgrade run.
Please show us the errors you see.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +