meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
linux:sw:openproject:migrate [2019/12/11 11:11] niziak |
linux:sw:openproject:migrate [2019/12/30 09:29] (current) niziak sw:linux:openproject:migrate renamed to linux:sw:openproject:migrate |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| Refer to instruction [[https://www.openproject.org/download-and-installation/]] to install OP. | Refer to instruction [[https://www.openproject.org/download-and-installation/]] to install OP. | ||
| - | <file /etc/apt/sources.list.d/openproject.list> | + | <code bash>apt-get install apt-transport-https</code> |
| + | |||
| + | <file | /etc/apt/sources.list.d/openproject.list> | ||
| # deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 10 main | # deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 10 main | ||
| deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | ||
| Line 18: | Line 20: | ||
| apt-cache policy openproject | apt-cache policy openproject | ||
| apt-get install openproject=9.0.4-1570023722.b1f1184d.stretch | apt-get install openproject=9.0.4-1570023722.b1f1184d.stretch | ||
| - | </codE> | + | </code> |
| <code bash> | <code bash> | ||
| Line 29: | Line 31: | ||
| Now we have running OP9.0.4 with PGSql. | Now we have running OP9.0.4 with PGSql. | ||
| + | |||
| + | |||
| + | ===== install pgloader ===== | ||
| + | |||
| + | refer to [[https://www.openproject.org/operations/migration-guides/migrating-packaged-openproject-database-postgresql/]] | ||
| + | <code bash> | ||
| + | wget -qO- https://dl.packager.io/srv/opf/pgloader-ccl/key | sudo apt-key add - | ||
| + | sudo wget -O /etc/apt/sources.list.d/pgloader-ccl.list \ | ||
| + | https://dl.packager.io/srv/opf/pgloader-ccl/master/installer/debian/9.repo | ||
| + | sudo apt-get update | ||
| + | sudo apt-get install pgloader-ccl | ||
| + | </code> | ||
| ===== import backup ===== | ===== import backup ===== | ||
| - | All backup parts are simply compressed directories and can be unpacked. | + | All backup parts are simply compressed directories and can be unpacked (or simply rsynced from another host). |
| Only database dump need to be imported. | Only database dump need to be imported. | ||
| + | Rsync command: | ||
| + | <code bash> | ||
| + | rsync -r -a -v -e ssh root@REMOTE:/var/db/openproject/files/ /var/db/openproject/files | ||
| + | </code> | ||
| ===== import mysql dump ===== | ===== import mysql dump ===== | ||
| Line 41: | Line 59: | ||
| </code> | </code> | ||
| - | <code bash>mysql<code> | + | <code bash>mysql</code> |
| <code sql> | <code sql> | ||
| CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'password'; | CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'password'; | ||
| Line 78: | Line 96: | ||
| ===== Upgrade OP to 10 ===== | ===== Upgrade OP to 10 ===== | ||
| - | <file /etc/apt/sources.list.d/openproject.list> | + | <file | /etc/apt/sources.list.d/openproject.list> |
| deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | deb https://dl.packager.io/srv/deb/opf/openproject/stable/9/debian 9 main | ||
| deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 9 main | deb https://dl.packager.io/srv/deb/opf/openproject/stable/10/debian 9 main | ||
| Line 84: | Line 102: | ||
| <code bash> | <code bash> | ||
| + | apt-get update | ||
| apt-cache policy openproject | apt-cache policy openproject | ||
| apt-get install openproject=10.0.0-1569215906.69231eeb.stretch | apt-get install openproject=10.0.0-1569215906.69231eeb.stretch | ||
| + | sudo openproject configure | ||
| + | |||
| + | apt-get upgrade | ||
| + | sudo openproject configure | ||
| </code> | </code> | ||