Hacker News new | ask | show | jobs
by shawabawa3 2233 days ago
I may be misremembering but I'm pretty sure you can backup like any postgres database with e.g. pg_dump

I think the premium distributed backup/restore thing is for backing up separate regional clusters individually

edit: looks like the premium option is a nice "BACKUP" command that handles uploading or downloading from cloud storage (e.g. s3) automatically. but for free you get "cockroach dump" which is similar to pg_dump

1 comments

The enterprise license gets you incremental backups.

cockroach dump is similar to pg_dump, but it's worth pointing out that pg offers a lot more than just pg_dump. Things like pg_basebackup (and accompanying tools) and various replication strategies and capabilities (e.g. recovery_min_apply_delay) make pg a vastly safer option from a DR point of view.