Installing Fedora 15 hosed my db...

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема Installing Fedora 15 hosed my db...
Дата
Msg-id 8C526286-7DC5-4C74-9EDF-6E10BC52C95E@gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: "interval hour to minute" or "interval day to minute"
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: set returning function with variable argument - possible?