Re: Backing up PostgreSQL DB on K8s

2021-06-08 Thread Daniel Standish
Perhaps it goes without saying but you might consider using cloud sql option such as aws rds, which provides persistence even if you destroy and rebuild your k8s cluster, and of course automated backups. On Tue, Jun 8, 2021, 10:41 PM Sumit Maheshwari wrote: > If you are backing up data to

Re: Backing up PostgreSQL DB on K8s

2021-06-08 Thread Sumit Maheshwari
If you are backing up data to safeguard against pod failures, then I believe that you can use a PV as data storage for PSql & it would survive any pod restarts. On Wed, Jun 9, 2021 at 5:01 AM Lewis John McGibbney wrote: > Hi users@, > Does anyone have a recommended/best practice/preferred way

Backing up PostgreSQL DB on K8s

2021-06-08 Thread Lewis John McGibbney
Hi users@, Does anyone have a recommended/best practice/preferred way for backing up PostgreSQL when Airflow is deployed into K8s? We were thinking of writing a maintenance DAG which would do this... maybe even contributing it to https://github.com/teamclairvoyant/airflow-maintenance-dags. I'm