> Source: [sk111794](https://support.checkpoint.com/results/sk/sk111794)

# sk111794 - Backup fails with "Cannot complete the backup process: mandatory pre-backup script failed" error

| Property | Value |
|----------|-------|
| Solution ID | sk111794 |
| Date Created | 2016-06-03 |
| Last Modified | 2016-11-30 |
| Technical Level | Advanced |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R82.10, R82, R81.20, R82.10, R82.x, R82.20, R82.x, R81.20, R82, R82.20 |
| OS | Gaia |

## Symptoms

- * Backup on R80 Security Management Server fails when executed from Gaia Clish or Gaia Portal with the following errors:

  `BACKUP operation failed`  
  `
  Details: Cannot complete the backup process: mandatory pre-backup script failed`
* */var/log/migrate.log* file contains the following errors:

  `
  [ExecCommandGetOutput] Going to execute command: 'bash -c "set -o pipefail; /opt/CPsuite-R80/fw1/bin/psql_dumpall_client -U postgres -c | grep -vwE '(^DROP ROLE (cp_postgres|postgres)|^CREATE ROLE (cp_postgres|postgres)|^ALTER ROLE (cp_postgres|postgres))' | /opt/CPsuite-R80/fw1/bin/upgrade_tools//gzip > /opt/CPsuite-R80/fw1/tmp/migrate//ren_db.gz"'`  
  `
  `  
  `
  [ExecCommandGetOutput] ERR: Command completed with error code 1`  
  `
  ... ... ...`  
  `
  pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off`  
  `
  pg_dumpall: pg_dump failed on database "template1", exiting`

## Cause

The configuration '*local template1 all password'* is missing from the *$PGDIR/data/pg_hba.conf* file.

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content