Upgrade PostgreSQL 9.3 to 9.6.1 on Windows while upgrading IDM from 4.5.5 to 4.6

0 Likes
over 4 years ago

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:

    Capture1

    Capture2

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


 

Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended