Wondering how to resolve Postgresql backup failed in Web help desk? We can help you.

As a part of our Server Management Service, we help our customers to fix PostgreSQL related errors regularly.

Today, let us see how our Support Techs fix this error.

How to backup the PostgreSQL database?

 
Let us see the steps followed by our Support Techs to backup.
 

1. Firstly, log in to Web Help Desk as an administrator.
2. Click Setup > General > Database.
3. Then, click the Vendor drop-down menu and select PostgreSQL.
4. (Optional) In the Backup Schedule row, select a weekly backup schedule.
5. Next, verify that the Backup Folder path is correct.
6. Finally, click Backup Now to back up the database.

How to Restore the PostgreSQL database using pgAdmin3?

1. Log in to Web Help Desk as an administrator.
2. Stop and start Web Help Desk
3. Go to <WHD install location>\WebHelpDesk\pgsql9\bin folder and click pgAdmin3.exe
4. Start pgAdmin3.
5. Click the connector icon.
6. In the New Server Registration window, enter the following parameters in the Properties tab, leaving the other fields empty or with default data:
   Name: WHDDB
   Host: localhost
   Port: 20293
   Username: whd
   Password: whd
   whd is the default password
7. In the pgAdmin3 Object Browser, expand Servers > WHDDB > Databases > whd.
8. Right-click whd and select Delete/Drop.
9. Right-click Databases and select New Database.
10. Enter whd as the new database name, whd as Owner in the dropdown
11. Go to Definition tab and set Collation and Character type to English_United_States.1252 in the dropdown lists
12. Click OK.
13. Right-click the new whd database and click Restore
14. Navigate to the database file or enter the filename
15. Select Custom in the Format
16. Leave Number of Jobs as blank
17. Select whd as the Rolename.
18. Click Restore.
19. Restart Web Help Desk (Stop and start Web Help Desk).

PostgreSQL backup failed in Web help desk

 
The following error displays on 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?

How to resolve PostgreSQL backup failed in Web help desk?

 
Let us see the steps followed by our Support Techs to resolve the error.

1. Firstly, verify if the database is running on PostgreSQL Embedded.
2. Then, 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. Next, 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. Then, start Web Help Desk.
9. Finally, create a backup.

[Need help to fix PostgreSQL error? We are available 24*7]

Conclusion

In short, today we saw how to backup the PostgreSQL database and fix PostgreSQL error.