Summary
How to backup and restore a database in a local abctl instance
Question
Hey all, when using a local abctl instance, anyone have pointers on how to backup and restore a database?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
["backup-and-restore", "local-abctl-instance", "database"]
Ah I found the kubectl file… can get it there probably.
KUBECONFIG=/home/USERNAMEHERE/.airbyte/abctl/abctl.kubeconfig ./kubectl -n airbyte-abctl exec airbyte-db-0 -- pg_dump -U docker db-airbyte > airbyte_backup_test.sql
The database data directory is available on the host under ~/.airbyte/abctl/data/airbyte-volume-db/
as well, but ya, pg_dump is probably easier to work with
That’s good to know too! thanks