Upgrade failure - Trying to start PostgresSQL server failed
Traces within the logs:
[SYSERR] [INFO] : java.lang.Exception: java.net.ConnectException: Trying to start PostgresSQL server failed
Please follow the steps below to address the same :
1. Stop the ServiceDesk Plus MSP service.
2. Open the command prompt in administrator mode. Go to ManageEnigne\ServiceDeskPlus MSP\bin and execute the shutdown.bat to shutdown properly.
3. In the same location executed the stopDb.bat to stop database properly if running.
4. Checked the task manager there should NOT be any postgres related to the product in running state. You can check this by right clicking the task->Open file location.
5. Provide FULL Control permission for the user "Everyone" to the ManageEnigne\ServiceDeskPlus MSPPGSQL folder.
6. Invoke the upgrade process now, that should work.
New to ADSelfService Plus?
Related Articles
Trying to start PostgresSQL server failed - While Upgrading
Error Trace. Trying to start PostgresSQL server failed java.net.ConnectException: Trying to start PostgresSQL server failed at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:177) at ...Steps to revert the environment from an upgrade failure situation ?
1. Rename the failed set up installation folder to <supportcenter_old> . Don't delete the installation folder until the process is completed. Download the existing version which you had before this upgrade from the below archives link. ...11.0 Upgrade failure Inputs needed for analysis
To analyze Supportcenter plus upgrade failure cases (Upgrade from 8121 - to 11.0 version), we need following types of logs. 1) If upgrade itself got failed -> need SCP\server\default\log for analysis 2) After upgrade, if the product does not start, ...10.5 Linux Upgrade failure and solutions
Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...Startup issue in Linux after fresh installation_Error code 10001
In certain scenario, the application cannot be started just after the fresh install. Below are the error traces, [06:24:57:427]|[10-11-2021]|[pglog]|[INFO]|[18]: -sh: 1: /root/ManageEngine/ServiceDeskPlus-MSP/pgsql/bin/pg_ctl: Permission denied| ...