| Lists: | pgsql-hackers |
|---|
| From: | Pavel Raiskup <praiskup(at)redhat(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | hhorak(at)redhat(dot)com |
| Subject: | pg_upgrade across more than two neighboring major releases |
| Date: | 2013-07-23 11:53:53 |
| Message-ID: | 11089098.N6sLmcoZsI@praiskup.usersys.redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Pavel Raiskup <praiskup(at)redhat(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, hhorak(at)redhat(dot)com |
| Subject: | Re: pg_upgrade across more than two neighboring major releases |
| Date: | 2013-07-23 12:48:16 |
| Message-ID: | CAB7nPqQXHFvmoabJj_m-5_Hs4iqakR64=cbTca4jbjhunUB4Vw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
Thanks,
--
Michael
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | Pavel Raiskup <praiskup(at)redhat(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, hhorak(at)redhat(dot)com |
| Subject: | Re: pg_upgrade across more than two neighboring major releases |
| Date: | 2013-07-23 13:04:41 |
| Message-ID: | 20130723130441.GA31490@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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. +