[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match