"Marcin Gil" <marcin(dot)gil(at)audax(dot)com(dot)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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-11-30 17:18:56|
|Subject: Re: views with parameters |
|Previous:||From: Kevin B.||Date: 2004-11-30 15:57:23|
|Subject: sequence newbie question|