Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable - Mailing list pgsql-admin

From Andy Shellam
Subject Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable
Date
Msg-id 4A37CC49.7000801@networkmail.eu
Whole thread Raw
In response to Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-admin
Hi,

> As Scott wrote: This is **not** yum's fault. It is your fault actually.
> Even if you did this upgrade from sources, it would still be broken.
> PostgreSQL does not guarantee not to change on-disk data structure
> between development snapshots.
>

I sort of agree with both sides of the issue - it's not entirely yum's
fault, nor is it PostgreSQL's fault, but neither is it the OP's (except
for the choice of using a different methodology to what normally works!)

As Konstantin mentioned in another e-mail, PostgreSQL is normally
compiled from source and installed into /usr/local/postgres-<version>.
Because yum silently upgraded the _existing_ installation, the old
version was no longer available to dump out the database.

Had the usual procedure been followed (installed from source) the
binaries from the previous version would still have been available in a
different directory to be able to dump/reload the database.

My 2p.

Regards,
Andy

pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Database Import..Please Help Me
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable