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

    • Install the PostgreSQL application by invoking TomcatPostgreSQL.exe
    • Do not provide any database details during installation
    • Complete the installation

     

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

     

  3. Navigate to the Postgres 961 directory. Right click on the Postgres directory and go to properties.
  4. Navigate to the security tab and click Edit.
  5. Select Users and provide complete permissions for users. (Selecting the checkbox next to Full Control will give complete permissions for the user)
  6. Navigate to the old Postgres directory. Right click on the Postgres directory and go to properties.
  7. Navigate to the security tab and click Edit.
  8. Select Users and provide complete permissions for users. (Selecting the checkbox next to Full Control will give complete permissions for the user)
  9. Click Apply.
  10. 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

     

  11. 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)
  12. Open command prompt.
  13. Set the PGPASSWORD using the following command:
    • set PGPASSWORD=<your pg password>

     

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

     

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

  16. Login to the windows machine as an administrator.
  17. Disable the old postgres service: This will ensure the old postgres service doesn’t startup automatically.
  18. Start the new postgres service. Change the Startup type to Automatic.

 

1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5 (1 votes, average: 5.00 out of 5)
You need to be a registered member to rate this post.
Loading...

Disclaimer: As with everything else at NetIQ Cool Solutions, this content is definitely not supported by NetIQ, so Customer Support will not be able to help you if it has any adverse effect on your environment.  It just worked for at least one person, and perhaps it will be useful for you too.  Be sure to test in a non-production environment.

Leave a Reply

No Comments
Kiran PS
By: Kiran PS
Apr 20, 2017
9:19 am
Reads:
1,026
Score:
5
Active Directory Authentication Automation Cloud Computing Cloud Security Configuration Customizing Data Breach DirXML Drivers End User Management Identity Manager Importing-Exporting / ICE/ LDIF Intelligent Workload Management Knowledge Depot LDAP Monitoring Open Enterprise Server Passwords Reporting Secure Access Sentinel Supported Troubleshooting Workflow