In a moment of madness I destroyed...

Поиск
Список
Период
Сортировка
От Jerry Levan
Тема In a moment of madness I destroyed...
Дата
Msg-id 12A6D0F4-BDB7-47E1-A38D-4797A43DE395@gmail.com
обсуждение исходный текст
Ответы Re: In a moment of madness I destroyed...  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: In a moment of madness I destroyed...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: In a moment of madness I destroyed...  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general
Today I updated my fedora machine from f19 to f20 without taking a
data dump.

When ‘fedup’ finished my 9.2.x binaries were updated to 9.3.x and
postgresql can no longer start…

I have all of the tables on another machine ( a mac  running 9.1.x postgresql) so no important
data was lost. ( My db consists primarily of all of my financial transactions
for the last 14 years and some miscellaneous tables for stashing other interesting information.)

Any suggestions for recovery would be appreciated.

Would a  text pg_dumpall from the mac be portable to the 9.3.x version on the PAE kerneled
fedora box?

It looks like I would at a minimum move the current pgsql directory and then do
the initdb and create user stuff…

I guess I could then possibly use the dblink stuff to suck the tables over one at a time…

Thanks

 Dazed and Confused Jerry








В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: HOT Standby & SSL
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: In a moment of madness I destroyed...