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. ...Failed to start the database
For the error "Failed to start the database", Check what database being used and, execute changeDBServer.bat. For Pgsql, Start PGSQL from the command link, execute StartDB.bat 65432 under C:\Manageengine\ServiceDesk\bin 65432 is the default port ...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| ...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 ...