In a moment of madness I destroyed... - Mailing list pgsql-general

From Jerry Levan
Subject In a moment of madness I destroyed...
Date
Msg-id 12A6D0F4-BDB7-47E1-A38D-4797A43DE395@gmail.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: HOT Standby & SSL
Next
From: Adrian Klaver
Date:
Subject: Re: In a moment of madness I destroyed...