Project

General

Profile

Task #7902

Story #6753: Upgrade production environment to use Ubuntu 14.04

update package dependency on postgresql-9.3

Added by Rob Nahf over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
d1_cn_buildout
Target version:
Start date:
2016-10-05
Due date:
% Done:

100%

Milestone:
None
Product Version:
*
Story Points:
Sprint:

Description

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.

History

#1 Updated by Rob Nahf over 3 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

#2 Updated by Rob Nahf over 3 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 30

#3 Updated by Dave Vieglais over 3 years ago

  • Status changed from In Progress to Closed
  • % Done changed from 30 to 100

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)