Feature Request: Snapshot-Based Backup and Restore for Full Database State #145

New Issue

MrUnknownDE · 2026-04-05T16:15:50+02:00

MrUnknownDE commented

2026-04-05 16:15:50 +02:00

Originally created by @Sohail2949000 on 2/10/2026

Description:
As a new user to self-hosting, I greatly appreciate the work put into this software. I’d like to suggest a feature that would help with testing and development workflows:

A snapshot-based backup and restore system for the entire database state—including all databases, roles, permissions, and related configurations. This would allow users to take a snapshot before testing new software, running experimental queries, or making database changes. If something goes wrong, we could quickly restore to that snapshot without affecting other applications or requiring complex recovery steps.

Use Case:

Before testing new applications or updates, take a snapshot of the full database environment.
If an issue arises (e.g., broken queries or misconfigurations), restore the snapshot to revert everything to the previous state.
Avoid impacting other services or applications during testing and recovery.

Benefits:

Simplifies safe experimentation for users new to self-hosting.
Reduces risk when making database changes.
Provides a straightforward way to recover from mistakes without full manual backups.

Thank you for considering this feature!

*Originally created by @Sohail2949000 on 2/10/2026* **Description:** As a new user to self-hosting, I greatly appreciate the work put into this software. I’d like to suggest a feature that would help with testing and development workflows: A snapshot-based backup and restore system for the entire database state—including all databases, roles, permissions, and related configurations. This would allow users to take a snapshot before testing new software, running experimental queries, or making database changes. If something goes wrong, we could quickly restore to that snapshot without affecting other applications or requiring complex recovery steps. **Use Case:** - Before testing new applications or updates, take a snapshot of the full database environment. - If an issue arises (e.g., broken queries or misconfigurations), restore the snapshot to revert everything to the previous state. - Avoid impacting other services or applications during testing and recovery. **Benefits:** - Simplifies safe experimentation for users new to self-hosting. - Reduces risk when making database changes. - Provides a straightforward way to recover from mistakes without full manual backups. Thank you for considering this feature!

MrUnknownDE closed this issue

2026-04-05 16:15:50 +02:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/databasus#145