Re: postgresql versions

["D'Arcy J.M. Cain" <darcy%NetBSD.org@localhost>]

On Fri, 19 Dec 2014 12:50:20 +0000
Roy Marples <roy%marples.name@localhost> wrote:
> Each time postgres is upgraded from one version to the next we have to
> dump and restore all the databases it uses as they change the on-disk
> format between versions.
> Sometimes that's an arduous task which I don't do that much.

That hasn't been true since 8.3 which is not in the pkgsrc tree
anyway. The pg_upgrade program supports upgrades from 8.3.X and later to
the current major release of PostgreSQL, including snapshot and alpha
releases.  I have run it a number of times and it has been pretty
painless each time.

-- 
D'Arcy J.M. Cain <darcy%NetBSD.org@localhost>
http://www.NetBSD.org/ IM:darcy%Vex.Net@localhost