Database

Postgres

Backup and Restore

Backup

k -n {namespace} exec {pod_name} -- sh -c 'PGDATABASE="$POSTGRES_DB" PGUSER="$POSTGRES_USER" PGPASSWORD="$POSTGRES_PASSWORD" pg_dump --clean' > backup.sql

Restore

cat backup.sql | kubectl exec -n {namespace} -it {pod_name} -- sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" psql -U $POSTGRES_USER $POSTGRES_DB'