On Fri, 29 Jul 2016 13:06:04 -0500 Larry Rosenman <ler@xxxxxxxxxx> wrote: > > Is that because it is hard to install the old and new clusters on > > the same server on FreeBSD? > > > The current FreeBSD Ports collection ports only allow ONE version to > be installed at a time. As does NetBSD. The problem is that unlike Python (which BSD allows multiple versions) there is only one executable to deal with. It's not an insurmountable problem but it could get messy. The answer is either chroot or mount and run pg_upgrade on another server. If you can afford the downtime you can also delete PG, install the new version and run pg_upgrade without modifying the existing DB. If it succeeds then replace the directories and restart the new version. If it fails then uninstall PG, reinstall the older version and restart. Lather, rinse, repeat until it upgrades cleanly. -- D'Arcy J.M. Cain <darcy@xxxxxxxxx> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 788 2246 (DoD#0082) (eNTP) | what's for dinner. IM: darcy@xxxxxxx, VoIP: sip:darcy@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general