Re: problematic upgrade - Mailing list pgsql-novice

From Tom Lane
Subject Re: problematic upgrade
Date
Msg-id 20720.1101830640@sss.pgh.pa.us
Whole thread Raw
In response to Re: problematic upgrade  ("Marcin Gil" <marcin.gil@audax.com.pl>)
Responses Re: problematic upgrade  ("Marcin Gil" <marcin.gil@audax.com.pl>)
List pgsql-novice
"Marcin Gil" <marcin.gil@audax.com.pl> writes:
> Now is there a way to recover (I have to give him a solution)?
> My thought: downgrade to 7.3.x, pg_dump, upgrade to 7.4, pg_restore.
> Will this work?

I don't think the 7.3 server will start up against the hacked-up
database, if that's what you mean.  If he can go back to the way things
were just before he started messing with the database, then certainly he
can pg_dump from the 7.3 installation and go forward from there.

Another possibility is to try pg_dump'ing from what he's got, but
I can't say that I'd have a lot of faith in the result.  You'd want
to examine the dump very carefully by hand before assuming it's good.

            regards, tom lane

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: views with parameters
Next
From: "Kevin B."
Date:
Subject: sequence newbie question