PGSQL Dump – Backup and Restore Procedure

PGSQL – DUMP – Backup Procedure :

1. Start the application

To take Postgres (Psql) Dump :

3. Open a command prompt and navigate into <ServiceDeskPlus-MSP>/pgsql/bin directory.

4.  Execute -> pg_dump -U postgres -p 65432 -h localhost servicedesk > outfile

This will create a file named “outfile” <ServiceDeskPlus-MSP>/pgsql/bin. Take a Copy of this file.

To restore :

1. Install the application in a different machine
2. Start and shut down the application once.

Paste the taken outfile under <ServiceDeskPlus-MSP>/pgsql/bin directory.
3. execute – startDB.bat 65432

4. Open a command prompt and navigate into <ServiceDeskPlus-MSP>/pgsql/bin directory.

psql -h localhost -p 65432 -U postgres -d servicedesk

5.Execute query \c postgres

6. Execute drop database servicedesk;

7. create database servicedesk;

8. Execute \q or quit.

9. Now execute -> psql -U postgres -p 65432 -h localhost servicedesk < outfile

10. Once the process is completed. Execute stopdb.bat 65432

11. Run the application and check the configuration

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500