pobox@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxx 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 //
