Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005

Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005

 Please follow the below instructions:

-> Go to <Installation-directory>/Servicedesk/lib folder and move the postgresql-42.2.16.jar to a different location as a backup.

-> Now download the jar from the below link and then place it inside the above lib folder.

-> Now initiate the upgrade.

Reference Tickets:

Issue ID:

SD-102480 (Released in 13006)

Upgrade Error Trace:

Sample 1: 
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : Caused by: org.postgresql.util.PSQLException: Der Verbindungsversuch schlug fehl. (The connection attempt failed)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at org.postgresql.Driver$ConnectThread.getResult(Driver.java:416)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at org.postgresql.Driver.connect(Driver.java:271)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at java.sql.DriverManager.getConnection(DriverManager.java:664)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at java.sql.DriverManager.getConnection(DriverManager.java:247)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at com.zoho.cp.ConnectionCreator.createConnection(ConnectionCreator.java:57)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at com.zoho.cp.ConnectionCreator.createConnectionInfo(ConnectionCreator.java:67)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at com.zoho.cp.ConnectionPool._getConnectionDetail(ConnectionPool.java:90)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : ... 40 more
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : Caused by: java.net.SocketException: Connection reset
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at java.net.SocketInputStream.read(SocketInputStream.java:210)
16.02.2022 08:33:07  [SYSERR]  [INFORMATION] : at java.net.SocketInputStream.read(SocketInputStream.java:141)


Sample 2:
Feb 5, 2022 1:49:17 PM  [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]  [INFO] : isServerStopped method returning status ::: true
Feb 5, 2022 1:49:17 PM  [com.manageengine.servicedesk.updatemgr.util.SDPrePostExtensionHandler]  [SEVERE] : Exception while creating pg_stat_statments and pg_trgm extension in postprocessor
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : org.postgresql.util.PSQLException: Connection attempt timed out.
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at org.postgresql.Driver.connect(Driver.java:271)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at java.sql.DriverManager.getConnection(DriverManager.java:664)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at java.sql.DriverManager.getConnection(DriverManager.java:247)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at com.manageengine.servicedesk.updatemgr.util.SDPrePostExtensionHandler.install(SDPrePostExtensionHandler.java:52)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1716)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1505)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:420)
Feb 5, 2022 1:49:17 PM  [SYSERR]  [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:270)

                    New to ADSelfService Plus?