This article explains the steps required to upgrade PostgreSQL 9.3 to 9.6.1 on Windows while upgrading IDM from 4.5.5 to 4.6.

1. Install Postgres 961 in a location where PostgreSQL older version is not installed:
   
   
   
   • Mount the Identity_Applications.iso image file, navigate to the directory containing PostgreSQL installer.
     

     products/RBPM/postgre_tomcat_install

   
   
2. Install the PostgreSQL application by invoking TomcatPostgreSQL.exe

• Do not provide any database details during installation

• Complete the installation

• Stop both old Postgres and the new Postgres services:
  
  
  
  • Go to Run and type cmd
  
  
• Input services.msc and click ok

• Search for the postgres 9.3 and postgres 9.6 services

• Select the service and click stop

• Navigate to the Postgres 961 directory. Right click on the Postgres directory and go to properties.

• Navigate to the security tab and click Edit.

• Select Users and provide complete permissions for users. (Selecting the checkbox next to Full Control will give complete permissions for the user)

• Navigate to the old Postgres directory. Right click on the Postgres directory and go to properties.

• Navigate to the security tab and click Edit.

• Select Users and provide complete permissions for users. (Selecting the checkbox next to Full Control will give complete permissions for the user)

• Click Apply.

• Create a postgres user by following the steps below:
  
  
  
  • Go to Control Panel\User Accounts\User Accounts\Manage Accounts
  
  
• Add a user account

• You will be taken to Add a user page

• Enter postgres as the User name and provide the necessary password

• Finish creating the user

• Login to the windows server as the postgres user. (Before you login as postgres user, make sure postgres user can connect to the windows server: Allow remote connection should be allowed to the postgres user)

• Open command prompt.

• Set the PGPASSWORD using the following command:
  
  
  
  • set PGPASSWORD=<your pg password>
  
  

• Change to the new postgres directory:
  
  
  
  • For example: C:\Users\postgres>cd C:\NetIQ\IdentityManager\apps1\postgresql962\bin
  
  

• Run the pg_upgrade command and click enter:
  
  

  C:\NetIQ\IdentityManager\apps1\postgresql962\bin>pg_upgrade.exe --old-datadir "C:\NetIQ\IdentityManager\apps1\postgres\data" --new-datadir "C:\NetIQ\IdentityManager\apps1\postgresql962\data" --old-bindir "C:\NetIQ\IdentityManager\apps1\postgres\bin" --new-bindir "C:\NetIQ\IdentityManager\apps1\postgresql962\bin"

  
  
  After performing the required consistency checks and upgrade, it shows the information below:
  
  
  
  
  

• Login to the windows machine as an administrator.

• Disable the old postgres service: This will ensure the old postgres service doesn't startup automatically.

• Start the new postgres service. Change the Startup type to Automatic.