Обсуждение: In a moment of madness I destroyed...

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

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.klaver@gmail.com

Jerry Levan <jerry.levan@gmail.com> writes:
> 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�

Install postgresql-upgrade and do "service postgresql upgrade".
More or less ... that's from memory, and I've not looked at that stuff
in nearly a year.  Read the README file under /usr/share/doc/postgresql*
to get the correct details.  And make a physical backup first, if the
data is that valuable to you.

A bigger question is why you don't have an organized backup plan to
begin with.  Especially if you're keeping priceless personal data
on such a bleeding-edge system as Fedora.  (I'll omit the blurb
for my former employer's commercial offering, other than to note
that I'm gladly paying their subscription price now that I don't
get it for free.  And I keep backups, too ;-))

            regards, tom lane

On Mon, Feb 3, 2014 at 1:33 AM, Jerry Levan <jerry.levan@gmail.com> wrote:
> Would a  text pg_dumpall from the mac be portable to the 9.3.x version on the PAE kerneled
> fedora box?
>

Of course.

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

Well, if data is still there, why not instlaling the binaries (e.g.
from source) related to such version and configure the daemon to run
against such pgdata? At least, this would be my first try.

Luca