Обсуждение: pg_upgrade across more than two neighboring major releases

Hello all,

don't know much about pg_upgrade implementation so I rather asking here before
I start trying the process once again with debugging and observing deeply
the code.

I tried to setup our postgresql RPM to package pg_upgrade in version
8.4.13 to automatize post-rpm-upgrade update of postgresql's data to
9.2.4.  I was unable to reach successful result (getting weird errors).

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..)

I can imagine that it may be difficult to handle everything even between two
following major releases - thus if it was possible, I would consider it as
heartwarming :).

Thanks for your answer,
Pavel

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@redhat.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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +