This article describes the automotive way to upgrade OA an databases to PostgreSQL 9.6
Note:The Instruction can be applied only for mangement nodes on RHEL\CentOS 7
Note: OA and BA services will be automatically restarted during database upgrade.
- OA MN system database
- BA DB
- Make sure that OA 7.0.1 with 130365 130373 is installed .
Make sure that disk space is enough to upgrade. The procedure required the same amount of free disk space as it already used by database.
To check used disk space execute command:
# du -sh /var/lib/pgsql/
To check free space:
# df -Ph /var/lib/pgsql/
# du -sh /var/lib/pgsql/ 1.2G /var/lib/pgsql/ # df -Ph /var/lib/pgsql/ Filesystem Size Used Avail Use% Mounted on /dev/ploop20534p1 40G 9.7G 28G 26% /
1.2Gis used by database. It means that additionally
1.2Gis required for migration.
28Gis available, to upgrade is possible
Download migrate-to-postgresql-96.tar.gz on the OSS MN.
Extract script by command
# tar -xf migrate-to-postgresql-96.tar.gz
Run script by command:
# cd migrate-to-postgresql-96 # python ./migrate-to-postgresql-96.py
When script finishes successfully, the entire OA system will start operation against the new version of PostgreSQL.