Article ID: 130077, created on Dec 28, 2016, last review on Apr 21, 2017

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.

Affected databases:

  • OA MN system database
  • BA DB

Preparation

  1. Make sure that OA 7.0.1 with 130365 130373 is installed .
  2. 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.

    1. To check used disk space execute command:

      # du -sh /var/lib/pgsql/
      
    2. To check free space:

      # df -Ph /var/lib/pgsql/
      

    For example,

    # 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% /
    

    In example 1.2G is used by database. It means that additionally 1.2G is required for migration. 28G is available, to upgrade is possible

  3. Download migrate-to-postgresql-96.tar.gz on the OSS MN.

  4. Extract script by command

    # tar -xf migrate-to-postgresql-96.tar.gz
    

Upgrade

  1. 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.

Email subscription for changes to this article
Save as PDF