LogoLogo
BlogDiscordGitHubDoltgres
  • Introduction
    • What is Doltgres?
    • Installation
    • Getting Started
  • Concepts
    • Git
      • Commits
      • Log
      • Diff
      • Branch
      • Merge
      • Conflicts
      • Remotes
      • Working Set
    • SQL
      • Databases
      • Schema
      • Tables
      • Primary Keys
      • Types
      • Indexes
      • Views
      • Constraints
      • Triggers
      • Functions
      • Procedures
      • Users/Grants
      • Transactions
      • System Variables
    • RDBMS
      • Server
      • Backups
      • Replication
  • Guides
    • Cheat Sheet
    • Replication from Postgres
  • Reference
    • Running the Server
      • Configuration
      • Access Management
      • Branch Permissions
      • Backups
      • Garbage Collection
      • Metrics
      • Replication
      • Troubleshooting
    • Version Control Features
      • Using Branches
      • Merges
      • Querying History
      • Using Remotes
      • Functions
      • System Tables
      • System Variables
    • SQL Language Support
      • Supported Functions and Operators
      • Supported Types
      • Supported SQL Commands
      • System Catalog Schema
    • Supported Clients
      • Programmatic
    • Benchmarks
      • Correctness
      • Latency
Powered by GitBook
On this page
  • What is a Backup?
  • How to use Backups
  • Difference between Postgres Backups and Doltgres Backups
  • Interaction with Doltgres Version Control
  • Not yet supported: non-remote backups
  1. Concepts
  2. RDBMS

Backups

PreviousServerNextReplication

Last updated 21 days ago

What is a Backup?

A backup is a copy of your database. You can restore the state of the database as it existed at the time of the backup.

How to use Backups

Backups are used for disaster recovery. When you create a backup it is wise to copy the backup to a different host. If you lose access to the host that houses your database, you restore the database from a backup on another host.

Backups have additional uses. Taking a backup of a database is often the easiest way to get a copy of the database. You can use this copy for development, testing, or analytics.

Difference between Postgres Backups and Doltgres Backups

Doltgres does not support any of the except the pg_dump method. Doltgres can create a dump pg_dump connected to the running Doltgres server.

Interaction with Doltgres Version Control

Doltgres supports different methods of backup that leverage Doltgres's git-style features.

Doltgres databases contain the entire history of the database, meaning Doltgres has backups built in to the running server. To restore to a previous point on a running server, you checkout the database at the commit you would like to restore to.

To replicate your database off host so you can restore if you lose the host, Doltgres supports two different concepts: remotes and backups.

Using a for backup allows you to back up all committed changes. You add a remote using the . Then you push a branch to a remote using the .

Not yet supported: non-remote backups

The backup command supported in Dolt is not yet available in doltgres. Check back for updates.

Postgres backup methods
remote
dolt_push() function
select dolt_remote() function