Backup Failed: Backup command returned exit code 1

10/18/2018 9:06 PM

1/30/2025 5:29 PM

The following error displays when clicking Backup Now in Web Help Desk Backup:

Backup command returned exit code 1: pg_dump: [archiver (db)] connection to database "whd" failed: could not connect to server: Connection refused (0x0000274D/10061)

Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

Backup command returned exit code 1:<br/><br/><font color='red'>pg_dump:[arhiver(db)] connection to database &quot;whdadmin&quot; failed" DATAL: &nbsp;database &quot;whdadmin&quot; does not exist <br/></font>

Web Help Desk

You are using Web Help Desk version 12.7.5 and below and have already changed the database credentials. Web Help Desk is still looking for the default credentials.
 

Resolution #1:

1. Verify if the database is running on PostgreSQL Embedded.
2. Check postgresql.conf if listen_addresses and port are commented (with #).
3. If not, edit postgresql.conf and verify that it is commented by adding # before listen_addresses and port.
4. Check the port assigned for whd.db.port in the .whd.properties file and verify that:
   • If the database is external postgresql, the port is 5432.
   • If the database is PostgreSQL Embedded, the port is 20293.
5. Create a backup of .whd.properties.
6. Stop the Web Help Desk service. Refer to Stop and start Web Help Desk.
7. Edit .whd.properties as per step 4 and save.
8. Start Web Help Desk.
9. Create a backup.

Resolution #2:
If you already changed the Web Help Desk database username, change it to its default credentials. 

• username: whd
• password: whd