ClickHouse / ClickHouse/ClickHouse
How To Backup/Restore While Preserving Disk For Partition
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 20h 33m
- Merged PRs (30d)
- 501
Description
### Company or project name
_No response_
### Question
Hi,
I'm using the builtin BACKUP and RESTORE commands. I've found that during a restore that the data partitions are not being sent onto the same disk as they were on the original backed up database. My setup has some small local disk with the majority of data being stored on S3. This means that the restore always runs out of local disk and fails. I have tried to write some script that runs during the restore to move partitions onto S3 while the restore is running but it seems like it can't keep up and eventually it still runs out of disk.
My question is, is there some parameter I'm missing when using the backup/restore commands to preserve some metadata about the partition disk?
Thanks,
Ricky
Contributor guide
Assessment
This issue has not been assessed yet.