Task #2903
Story #2720: KNB, LTER, PISCO, ESA, SANPARKS roll out
Task #2881: ESA + PARC MN upgrade
Task #2845: Build new ESA server on mn-ucsb-2.dataone.org
Migrate postgres DB for ESA
Status:
Closed
Priority:
Normal
Assignee:
Ben Leinfelder
Category:
-
Target version:
Start date:
2012-06-10
Due date:
% Done:
100%
Milestone:
CCI-1.0.0
Product Version:
*
Story Points:
Sprint:
Description
Current production ESA db has Metacat 1.9.2 structure. Testing the sequential upgrade through 1.9.3->4->5->2.0.0 will be good.
On original server:
sudo -u postgres bash -c "/usr/bin/pg_dump -Fc esa > /tmp/esa.dump"
scp /tmp/esa.dump leinfelder@mn-ucsb-2.dataone.org:/tmp/esa.dump
On target ESA:
sudo -u postgres bash -c "/usr/bin/pg_restore -d esa /tmp/esa.dump"
History
#1 Updated by Ben Leinfelder over 12 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 90
The upgrade worked perfectly.
#2 Updated by Ben Leinfelder over 12 years ago
- Status changed from In Progress to Closed
