Re: postgresql versions

[Roy Marples <roy%marples.name@localhost>]

On 19/12/2014 13:08, D'Arcy J.M. Cain wrote:
> 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.

Interesting.

http://www.postgresql.org/docs/9.2/static/pgupgrade.html

Implies that both old server and new server need to be running on the
same box. I wasn't aware our pkgsrc support that as they share the same
rc.d script?

Roy