Re: problematic upgrade

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

In response to

Browse pgsql-novice by date

  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