Exporting internal DB to external DB for Airbyte

Slack Knowledge Base Q&A Platform Questions
, , , ,
1

Summary

Exporting an already populated internal DB used by Airbyte to an external DB and facing errors. Steps involve taking a dump of the internal DB, importing it into an external Postgres server, and updating the .env file with new DB host, name, and user.


Question

Hi I am trying to export an already populated internal DB that airbyte uses to an external db. Is it a good idea to do it ? As Ive been facing different kinds of errors
Steps I did.

  1. Take a dump of the internal db
  2. Import that dump in an external postgres server
  3. Change .env file of airbyte to the new db host , db name, and user to connect

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

["exporting-internal-db", "external-db", "airbyte", "errors", "dump", "postgres", ".env-file"]
2

what kind of errors are you facing? the way you did it should work