On Feb 23, 2006, at 9:21 AM, pobox@verysmall.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).
Upgrade from what to what?
If you're upgrading from 8.0.x to 8.0.y then there is no dump/reload.
If youre going from < 8.1 to 8.1 then there is dump/reload OR you can
use some sort of replication such as slony to copy the data, then
have a few seconds of downtime while you turn off the older DB and
put the 8.1 in its place.