Re: Installing Fedora 15 hosed my db... - Mailing list pgsql-general

From Tom Lane
Subject Re: Installing Fedora 15 hosed my db...
Date
Msg-id 8901.1308254703@sss.pgh.pa.us
Whole thread Raw
In response to Installing Fedora 15 hosed my db...  (Jerry LeVan <jerry.levan@gmail.com>)
Responses Re: Installing Fedora 15 hosed my db...  (Jerry LeVan <jerry.levan@gmail.com>)
List pgsql-general
Jerry LeVan <jerry.levan@gmail.com> writes:
> Yesterday I upgraded from fedora 14 to fedora 15...
> The install process sorta trashed my 8.4 db...here is
> what I have:
> postgresql-server-9.0.4-1.fc15.i686
> postgresql-pltcl-8.4.4-1PGDG.fc12.i386
> postgresql-docs-8.4.4-1PGDG.fc12.i386
> postgresql-libs-9.0.4-1.fc15.i686
> postgresql-contrib-8.4.4-1PGDG.fc12.i386
> postgresql-9.0.4-1.fc15.i686
> postgresql-plpython-8.4.4-1PGDG.fc12.i386
> postgresql-devel-8.4.4-1PGDG.fc12.i386

> Any suggestions on how I can cleanup the mess I created *and* get
> a complete 9.0.4 installation?

Well, you could
    (1) remove all the PGDG RPMs,
    (2) install the regular Fedora postgresql RPMs,
            including postgresql-upgrade
    (3) run "service postgresql upgrade"

(I haven't actually tested postgresql-upgrade in the context of
upgrading from 8.4 PGDG RPMs instead of the regular Fedora ones, but
in theory it should work.  As always, a filesystem backup of your
database is a good thing to have in case of disaster.)

            regards, tom lane

pgsql-general by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: You could be a PostgreSQL Patch Reviewer!
Next
From: Alexander Farber
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening