Hi! I am trying to connect my Airbyte db to an ext...
# ask-community-for-troubleshooting
e
Hi! I am trying to connect my Airbyte db to an external postgres database, per these instructions. I understand how to change the environment variables to point to the new db - but how do I transfer the data that already exist in the airbyte db over to the external postgres db I want to use going forward? Is there something I need to do to get Airbyte to start sending data to the new db? Thanks in advance for your help 🙏
1
u
You can export all the config/connections in the Setting page. Run
docker-compose down
change your
.env
file and
docker-compose up
with the external database. After that you should be able to import the config/connection file
e
where do I need to go to get the docker-compose.yml again? I'm hitting this:
I'm deployed on a GCP compute instance, per these instructions
oh, it looks like I need to wget and cd into the airbyte repo, I'm being dumb
u
if you follow the instructions
the instance has an airbyte folder
s
How to find and edit the .env file?
m
The .env file is in the same folder of the docker-compose file you downloaded.