Hi,
If the downtime is a concern, you could use Slony-1 for the migration.
Philippe Ferreira.
pobox@xxxxxxxxxxxxx napisał(a):
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).
here you are:
http://www.postgresql.org/docs/8.1/static/migration.html
If both PostgreSQL versions can't coexist on one host, you can use
another one, with possibly identical setup (HW/OS/etc) for the
migration, and transfer (use tar + netcat for minimal downtime) the
cluster afterwards.
