Channels
announcement
contributors
github
questdb-linen
random
users-market-data
users-public
Powered by
Title
a
Ajay Pilaniya
01/07/2023, 11:32 PM
Is there any way to copy table data from one QuestDB server to another QuestDB server?
a
Andrey Pechkurov
01/09/2023, 7:43 AM
Hi Ajay, The simplest way would be to copy the table dir while the database is stopped. If a downtime is not an option, you could do a table backup:
https://questdb.io/docs/reference/sql/backup/
If you want to create a 1-to-1 copy of the database, it's possible to use EBS snapshots to do that on the EBS volume level:
https://questdb.io/docs/operations/backup/#creating-a-filesystem-backup-disk-snapshot
Finally, we have a CLI utility that copies the specified table over ILP:
https://github.com/questdb/questdb/tree/0a45a77a60073729e33b78f986bb46dd8fc99a68/utils#copy-table-from-one-instance-to-another-using-postgres-wire-to-read-and-ilp-to-write
5 Views
#users-public
Join Slack