Skip site navigation (1) Skip section navigation (2)

Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Konstantin Gredeskoul <kig(at)dropinmedia(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable
Date: 2009-06-16 04:10:35
Message-ID: dcc563d10906152110y58c2e51aya76d6b7c762dd207@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Jun 15, 2009 at 4:42 PM, Konstantin
Gredeskoul<kig(at)dropinmedia(dot)com> wrote:
> Dear PostgreSQL admins and gurus,
>
> I always knew that installing Postgres using Yum/RPM/etc is a very bad idea,
> but decided to try it on one my boxes that runs local wiki/Trac.
>
> I added /etc/yum.repos.d/pgdg-84-centos.repo to my yum configuration and
> installed PostgreSQL version 8.4devel_20090310-1PGDG.rhel5.i386
>
> Today I ran "yum update", which quietly upgraded my installation to
> "8.4rc1-1PGDG.rhel5.i386" and now my server does not start.
>
> -bash-3.2$ pg_ctl --version
> pg_ctl (PostgreSQL) 8.4rc1
> -bash-3.2$ pg_ctl -D /db/data start
> server starting
> -bash-3.2$ FATAL:  database files are incompatible with server
> DETAIL:  The database cluster was initialized with CATALOG_VERSION_NO
> 200902242, but the server was compiled with CATALOG_VERSION_NO 200904091.
> HINT:  It looks like you need to initdb.
>
> I do NOT have a pg_dump of the database because I did not anticipate this
> idiocy.
>
> I am looking for any help on how I can revert back to the previous version
> of PostgreSQL so that I can read the database, do pg_dump, and never EVER
> use yum again to upgrade it.

This is NOT yum's fault.  PostgreSQL does not guarantee data directory
consistency from one rc to another, through beta, etc.  Until 8.4.0
comes out, it could change each and every time.

Got a backup of the original 8.4devel_20090310-1PGDG.rhel5.i386
package?  I'd think reinstalling that would fix your problen.

In response to

Responses

pgsql-admin by date

Next:From: Devrim GÜNDÜZDate: 2009-06-16 04:56:41
Subject: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendereddata unusable
Previous:From: Premila DeviDate: 2009-06-16 03:15:09
Subject: FW: Database Import..Please Help Me

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group