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

From Jerry LeVan
Subject Installing Fedora 15 hosed my db...
Date
Msg-id 8C526286-7DC5-4C74-9EDF-6E10BC52C95E@gmail.com
Whole thread Raw
List pgsql-general
>
>
> On Jun 16, 2011, at 5:16 PM, Dagan McGregor wrote:
>
>> On Thu, 16 Jun 2011 15:01:30 -0400, Jerry LeVan wrote:
>>> 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?
>>
>> Just curious, why do you have Fedora 12 packages in the package list, if you're running Fedora 14? If you've been
upgradingfrom Fedora 12, that would be part of the problem. Fedora doesn't update between older versions all that well. 
>>
>> I'd suggest, if you do have a data back-up, it would be easier to do a clean install of Fedora 15.
>>
>> Dagan
>
As I noted earlier today, I had made postgresql 'invisible' to yum in the fedora repo...

When I made it visible all of the missing f15 postgresql rpms showed up in yumex.

When I installed the missing rpms the older fedora rpms vanished and I was able
to do as Tom suggested:

  service postgresql pg_upgrade

and the conversion was successful :)

I am now running version Pg 9.0.4.

Jerry




pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: "interval hour to minute" or "interval day to minute"
Next
From: "David Johnston"
Date:
Subject: Re: set returning function with variable argument - possible?