Re: postgresql versions

[Filip Hajny <filip%joyent.com@localhost>]

19. 12. 2014 v 14:15, 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?

For the pg_upgrade tool, yes. We had support for sub-prefixed PG installations at some point, which made coexistence possible, but it was never finished and/or introduced issues when building dependent packages, which was likely the reason it was removed.

The good old upgrade still works though - i.e. to create a dump, replace packages, import. Doesn’t make it any less annoying of course.

-F