From: | "Marcin Gil" <marcin(dot)gil(at)audax(dot)com(dot)pl> |
---|---|
To: | "'PGSQL-Novice'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: problematic upgrade |
Date: | 2004-12-01 08:19:14 |
Message-ID: | 20041201081914.4CF291881CC0@hermes2.vernet.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
----Original Message----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Tuesday, November 30, 2004 5:04 PM
To: Marcin Gil
Cc: 'PGSQL-Novice'
Subject: Re: [NOVICE] problematic upgrade
> 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.
>
I think it's the only reasonable solution. Thrash all data for now,
recover from an old backup @ 7.3 and dump; restore @ 7.4 and refill
missing data. Lotta job but it is better then hand-check all dumps from
this 7.4-hacked.
Thank all of you,
-Marcin Gil
From | Date | Subject | |
---|---|---|---|
Next Message | Akbar | 2004-12-01 11:18:41 | remove too much space between words of the string |
Previous Message | Thomas Hermann(Software) | 2004-12-01 07:48:04 | Re: views with parameters |