Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Forgot to dump old data before re-installing machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dave Page" <dpage(at)postgresql(dot)org>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-patches(at)postgresql(dot)org, "Stefan Schwarzer" <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Subject: Re: [GENERAL] Forgot to dump old data before re-installing machine
Date: 2008-01-18 21:12:20
Message-ID: 12790.1200690740@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-patches
"Dave Page" <dpage(at)postgresql(dot)org> writes:
> On 18/01/2008, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>> I didn't follow how the user got into this mess, so I don't know whether the
>> suggestion "you need to initdb" is appropriate.

> I would think not, as you almost certainly must be doing a file level
> restore of the data directory to get into this state and therefore
> probably want to keep your data.

You could argue that that's true if there's an incompatible pg_control
file there at all; I'm not sure why wrong-endianness is different from
wrong-version or wrong-datetime-option or anything else.

IIRC the HINT to initdb was originally kind of pointed at developers
who'd just downloaded a new CVS update with a new catversion number.
It might not be so appropriate for the field.  The worst case scenario
would be someone blindly following the hint and blowing away their old
data ...

			regards, tom lane

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2008-01-18 21:14:51
Subject: Re: Forgot to dump old data before re-installing machine
Previous:From: Greg SmithDate: 2008-01-18 19:48:11
Subject: Re: Forgot to dump old data before re-installing machine

pgsql-general by date

Next:From: Tom LaneDate: 2008-01-18 21:14:51
Subject: Re: Forgot to dump old data before re-installing machine
Previous:From: Bricklen AndersonDate: 2008-01-18 21:07:25
Subject: Re: 7.4.6 to 8.2.5 - ' changes to $_$

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group