> Bruce Momjian wrote:
> > > IMHO, again, it is better to _know for a fact_ that a dump/reload is
> > > going to be required _every_ major version upgrade than to have
> > > surprises -- and to have to use a db that has been coded around
> > > backwards compatibility.
>
> > pg_upgrade works from version 6.5.* to 7.0. That does not require a
> > dump/reload.
>
> Oh yeah... forgot about pg_upgrade.... It was easy to overlook, since
> it _didn't_ work for upgrading to 6.5. Which reminds me of an update I
> need to make to the migrations scripts for the RPM's.....
Yes, it is one of those, "Gee it really works" kind of utilities.
Certainly helps people upgrade database even while we are playing with
system catalogs during early betas. We certainly aren't going to change
the on-disk data format during beta, and that is all it relies on.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
