Title
d
David Bellizzi
03/21/2023, 6:22 PMHey there questdb folks, I need to migrate our data to the new instance. Is there a documented process on how to do that?
a
Andrey Pechkurov
03/21/2023, 6:52 PMHi David,
You can use a full backup or something like EBS snapshots:
https://questdb.io/docs/operations/backup/
d
David Bellizzi
03/21/2023, 6:54 PMOh sorry I was not clear. This data is onprem in a k8s cluster. Is there a way I can sql dump and then copy it off and then do sql import?
a
Andrey Pechkurov
03/21/2023, 7:01 PMYou should be able to copy a full backup directory to a machine running in k8s
d
David Bellizzi
03/21/2023, 7:06 PMThe machine is a container in a pod that is mounting a PV on a ONTAP or SOLIDFIRE external storage array. So do I need to initiate a backup and then copy the backup dir to the new pods PV. Is there something I need to do reach the new data?
a
Andrey Pechkurov
03/21/2023, 7:17 PMYes, you'd need to follow these steps to restore from the backup:
https://questdb.io/docs/operations/backup/#restoring-from-a-backup
Alternatively, you could try cloning the disk if it's possible in your setup
d
David Bellizzi
03/21/2023, 7:18 PMThanks I'll checkout the docks