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

# sk164656 - Restoring from a backup fails with "ERROR: role "ROLENAME" does not exist"

| Property | Value |
|----------|-------|
| Solution ID | sk164656 |
| Date Created | 2020-01-30 |
| Last Modified | 2020-02-02 |
| Technical Level | Advanced |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R82.10, R82, R81.20, R82.10, R82.20, R81.20, R82, R82.20 |

## Symptoms

- Restore from backup shows:  

```
ERROR: role "ROLENAME" does not exist
mds_restore> Failed to restore the database.
```

## Cause

There are more than the default Postgres roles (cp_postgres and postgres) defined.

## 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