Prerequisites
Check number of files in each release
cd /git/docker/policy-db-migrator/src/main/docker/config/policyadmin/sql$
ls 0800/upgrade/*.sql | wc -l
96
ls 0900/upgrade/*.sql | wc -l
13
ls 0800/downgrade/*.sql | wc -l
96
ls 0900/downgrade/*.sql | wc -l
13
Upgrade scripts:
/opt/app/policy/bin/prepare_upgrade.sh policyadmin
/opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
Downgrade scripts:
/opt/app/policy/bin/prepare_downgrade.sh policyadmin
/opt/app/policy/bin/db-migrator -s policyadmin -o downgrade -f 0900 -t 0800
Db migrator initialization script:
To run scripts update /oom/kubernetes/policy/resources/config/db_migrator_policy_init.sh with the appropriate calls.
Fresh Install
Number of files run = 109
Tables in policyadmin = 75
Records in policyadmin_schema_changelog = 109
Version in schema_versions: 0900