Moving from internal Postgres db to RDS in Airbyte on Kubernetes

Summary

User is looking to move from using the internal Postgres db in Airbyte on Kubernetes to an RDS instance. They are concerned about not losing sync information and are asking if they have to manually copy data or if there is an easier way.


Question

Hi everyone, I’ve just started testing out Airbyte on a kubernetes cluster via Helm. I started syncing several tables using the default / internal postgres db kubernetes service. I’d like to move to using an RDS instance, and was wondering if there’s a way to make sure I don’t lose the information on all the syncs. Do I have to copy data from one postgres instance to another? Would there be an easier way?

I tried <#C01AHCD885S|ask-ai>, and it https://airbytehq.slack.com/archives/C01AHCD885S/p1711561863403219?thread_ts=1711561839.643569&amp;cid=C01AHCD885S|recommended that I ask the community. Thank you in advance! :slightly_smiling_face:



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

["moving-from-internal-postgres-db", "rds-instance", "airbyte", "kubernetes", "data-sync"]

Unfortunately today you must export -> import manually the database. You can use pg_dump to do it