Upgrading ADAudit Plus PostgreSQL database to version 17.5

ADAudit Plus will no longer support PostgreSQL version 9.4.x and earlier starting from build 8520. If you are using PostgreSQL version 9.4.x or earlier, we recommend upgrading the database to version 17.5.

How to check your database type and PostgreSQL version

1. Check database type
   • Log in to the ADAudit Plus web console, and click the Support tab.
   • On the Support Info tile, click More
   • Under Basic Check, expand the Machine Details drop-down to view your Database and Build Number (listed at the bottom).
2. Check PostgreSQL version
   • Open Command Prompt as an administrator in the <product_home>\pgsql\bin> directory.
   • Run the command: postgres.exe -V

     The installed PostgreSQL version will be displayed.

     Note:

     If you are using PostgreSQL version 10.x, the steps below do not apply. Please contact the ADAudit Plus support team to obtain the upgradation steps.

Prerequisites

Storage

• Ensure at least twice the size of the current <product_home>\pgsql folder is available for upgrading the PostgreSQL version.

Product build

• These steps apply only to builds 8500 and above. If you are on a version earlier than 8500, upgrade to build 8500 first and then follow the below steps.

Required files

• Download and extract the required component files before starting the PostgreSQL upgrade.

  Files	SHA256 Checksum hash value
  PostgreSQL-Upgrade-17.5 Note: Files included in the above folder: pgsql file folder AdventnetADAPCmdUtil.jar AdvTools.jar	73AC5F3B87129BEA62F97B86BDE8A8BD54645DC96339B74D06787832F6643CD2

Steps to upgrade PostgreSQL to version 17.5

A. Backup and initial setup

1. Stop the product.
2. From the <product_home>\lib folder, move the existing AdvTools.jar and AdventnetADAPCmdUtil.jar to a safe location.
3. Place the newly downloaded AdventnetADAPCmdUtil.jar file into the <product_home>\lib folder.
4. Place the newly downloaded patched AdvTools.jar into the <product_home>\lib folder.
5. From the <product_home>\bin folder, open Command Prompt as an administrator and start the database by running:

   startDB.bat

6. Run a database backup using backupDB.bat from the <product_home>\bin folder, specifying your preferred backup location and password.

   backupDB.bat

   Note:

   • The backup file will be saved by default in <product_home>\backUp folder as OfflineBackup_<timestamp>.ezip
   • An EventData back up folder will also be created under <product_home>\backUp\EventData\<timestamped-folder>.
7. Once the backup is complete, stop the database by running:

   stopDB.bat

B. Configure database parameters

8. Back up the <product_home>\conf\database_params.conf file by copying it to a safe location.
9. Open Command Prompt as an administrator from the <product_home>\bin folder, and set the product to standalone mode by running:

   cmdUtil.bat

10. Sign in with the default product admin Username and Password.
11. Once you see the message "Welcome admin!", retrieve your PostgreSQL database password by running:

    servicepack getting-db-password postgres

12. Note down the password in a text editor.
13. Stop the Command Utility (cmdUtil.bat) by pressing: Ctrl + C
14. Open the <product_home>\conf\database_params.conf file in a text editor and add:

    superuser_pass=<Noted password>

15. Save and close the file.

C. Replace the pgsql folder

16. Rename the existing pgsql folder in <product_home> to pgsql_old.
17. Copy the newly downloaded pgsql folder and place it into the <product_home> folder.

     

    

     

18. Navigate to the <product_home>\bin folder, open Command Prompt as an administrator, and run the command:

    startADAP.bat

19. After verifying that the product starts successfully, stop the service by pressing: Ctrl + C.

D. Restore the database

20. Restore the database using the previously saved backup by running:

    RestoreDB.bat <product_home>\backUp\OfflineBackup_<timestamp>.ezip -p Backup@123$.

    Note:

    • When backupDB.bat is run, the backup zip file is secured with the default password: Backup@123$ for restoration.
21. From the <product_home>\bin folder, open Command Prompt as an administrator and start the database by running:

    startDB.bat

22. Restore event data using the previously saved backup by running:

    RestoreEventTables.bat <product_home>\backUp\EventData\<timestamped-folder>

23. Stop the database again by running:

    StopDB.bat

You have successfully updated the PostgreSQL version to 17.5.