| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Jerry Levan <jerry(dot)levan(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: In a moment of madness I destroyed... |
| Date: | 2014-02-03 00:54:15 |
| Message-ID: | 52EEE8B7.1020908@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/02/2014 04:33 PM, Jerry Levan wrote:
> 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?
Yes.
>
> It looks like I would at a minimum move the current pgsql directory and then do
> the initdb and create user stuff…
So the upgrade overwrote you $DATA directory?
>
> I guess I could then possibly use the dblink stuff to suck the tables over one at a time…
>
> Thanks
>
> Dazed and Confused Jerry
>
>
>
>
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-02-03 05:53:45 | Re: In a moment of madness I destroyed... |
| Previous Message | Jerry Levan | 2014-02-03 00:33:21 | In a moment of madness I destroyed... |