Thread: 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.