Re: upgrade PostgreSQL 8.x on production FreeBSD

pobox(at)verysmall(dot)org wrote:
> Could anybody point to an on-line resource about the steps involved with
> upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
> downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 -
> upgrade (ports) 4 - import 5- start db).

You want to make your dump with the pg_dump of the new version. I'm not
sure you can build the tools seperately (that'd be excellent, but my
FreeBSD boxes are at home)...

I think it should be:
1 - make postgresql,
2 - make install postgresql-tools
3 - dump
4 - stop db
5 - make install postgresql
6 - restore
7 - start db

--
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //