ManageEngine ServiceDesk Plus MSP external PostgreSQL Database

If you want to install ServiceDesk Plus to external PostgreSQL Database, you need:

1) Install ServiceDesk Plus and run at first time with internal DB (./bin/run.sh);

2) log in ServiceDesk Plus and add task, for example and logout;

3) shutdown ServiceDesk Plus (./bin/shutdown.sh -S)

) run ./bin/changeDBserver.sh and save new settings

4) run startDB and dump internal DB ( ./pgsql/bin/pg_dump -h localhost -p 65432 -U postgres -w servicedesk -f dump.sql ) after stopDB.sh

5) restore dump in external DB

sudo -u postgres bash

 psql -U postgres —password —dbname servicedesk -f dump.sql

6)change in /server/default/conf/nms-service.xml

StartDBServer false

7) see /server/default/deploy/postgres-ds.xml to right preferences

8) run