Story #6753: Upgrade production environment to use Ubuntu 14.04
update package dependency on postgresql-9.3
ubuntu 14.04 doesn't support postgresql 9.1. Metacat has migrated to support 9.3, which is not the latest (9.5), but sufficient.
#1 Updated by Rob Nahf over 4 years ago
this involves ultimately replacing the postgresql dependency in one of the control files in cn-buildout with 9.3.
For DEV deployments, once you upgrade the OS to 14.04, postgresql is automatically upgraded to 9.3. There is a manual migration of the database that has to be done to make it 9.3 compatible:
root@cn-dev-unm-2:/etc# pg_dropcluster --stop 9.3 main
root@cn-dev-unm-2:/var/lib/postgresql# /etc/init.d/postgresql stop
root@cn-dev-unm-2:/var/lib/postgresql# rsync -a /var/lib/postgresql/9.1 /var/lib/postgresql/9.1.backup
root@cn-dev-unm-2:/var/lib/postgresql# pg_upgradecluster 9.1 main /var/lib/postgresql/9.3
after you know everything works:
root@cn-dev-unm-2:/var/lib/postgresql# pg_dropcluster --stop 9.1 main
root@cn-dev-unm-2:/var/lib/postgresql# rm -r /var/lib/postgresql/9.1.backup