Backup and Restore Database in local abctl instance

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