Обсуждение: upgrading from 9.3-beta1 to 9.3-beta2 requires dump & reload?
Greetings, I just got around to upgrading from 9.3-beta1 to 9.3-beta2, and was surprised to see that the server was refusing to start. In the log, I'm seeing: 2013-07-24 13:41:47 PDT [7083]: [1-1] db=,user= FATAL: database files are incompatible with server 2013-07-24 13:41:47 PDT [7083]: [2-1] db=,user= DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 201305061, but the server was compiled with CATALOG_VERSION_NO 201306121. 2013-07-24 13:41:47 PDT [7083]: [3-1] db=,user= HINT: It looks like you need to initdb. I'm using the RPMs from yum.postgresql.org on RHEL6. Is this expected, intentional behavior? Do I really need to dump & reload to upgrade between beta releases of 9.3, or is there some more efficient way? thanks
Lonni J Friedman escribió: > I'm using the RPMs from yum.postgresql.org on RHEL6. Is this > expected, intentional behavior? Do I really need to dump & reload to > upgrade between beta releases of 9.3, or is there some more efficient > way? We try to avoid forcing initdb between beta versions, but it's not guaranteed. You should be able to use pg_upgrade, also. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Lonni J Friedman escribi�:
>> I'm using the RPMs from yum.postgresql.org on RHEL6. Is this
>> expected, intentional behavior? Do I really need to dump & reload to
>> upgrade between beta releases of 9.3, or is there some more efficient
>> way?
> We try to avoid forcing initdb between beta versions, but it's not
> guaranteed. You should be able to use pg_upgrade, also.
Unfortunately, the RPMs probably won't be very helpful for using
pg_upgrade, since there's no convenient way to get beta1 and beta2
postmaster executables installed at the same time (unless Devrim
foresaw this case and packaged things differently than I did for
Red Hat ;-)).
regards, tom lane
On Wed, Jul 24, 2013 at 2:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Alvaro Herrera <alvherre@2ndquadrant.com> writes: >> Lonni J Friedman escribió: >>> I'm using the RPMs from yum.postgresql.org on RHEL6. Is this >>> expected, intentional behavior? Do I really need to dump & reload to >>> upgrade between beta releases of 9.3, or is there some more efficient >>> way? > >> We try to avoid forcing initdb between beta versions, but it's not >> guaranteed. You should be able to use pg_upgrade, also. > > Unfortunately, the RPMs probably won't be very helpful for using > pg_upgrade, since there's no convenient way to get beta1 and beta2 > postmaster executables installed at the same time (unless Devrim > foresaw this case and packaged things differently than I did for > Red Hat ;-)). Sounds like I'm out of luck. Thanks anyway.