
Theoretically, should one be able to do:

pg_dumpall > db.out
remove 7.0.3 bin, lib, data, etc
install 7.1 bin, lib, etc
initdb 7.1
psql template1 < db.out

Basically, has anyone actually tried *that* yet and can report on whether
or not it works?

I'm just about to try it here, on >2gig of data, but if others have
experience with this, that would be great ...


Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


Tue, 10 Apr 2001 14:24:33 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Going from 7.0.3 -> 7.1 ...
On Tue, Apr 10, 2001 at 02:24:33PM -0300, The Hermit Hacker wrote:
> 
> Theoretically, should one be able to do:
> 
> pg_dumpall > db.out
> remove 7.0.3 bin, lib, data, etc
> install 7.1 bin, lib, etc
> initdb 7.1
> psql template1 < db.out
> 
> Basically, has anyone actually tried *that* yet and can report on whether
> or not it works?

Well, 7.0 pg_dump does not get the dependencies right...  But in
that case the 7.0 -> 7.0 import also does not work.

> I'm just about to try it here, on >2gig of data, but if others have
> experience with this, that would be great ...

In my project, there is need for this well-known RDBMS tool
knows as 'vi'...  ;)


-- 
marko


Tue, 10 Apr 2001 21:32:33 +0200
Marko Kreen <marko@l-t.ee>
Re: Going from 7.0.3 -> 7.1 ...