https://questdb.io logo
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