Troubleshooting Data Platform

Re-creating airflow database in PostgreSQL

Connect to PostgreSQL database

If client pod is not created

CODE

export POSTGRES_PASSWORD=$(kubectl get secret --namespace ef-external ef-postgresql -o jsonpath="{.data.password}" | base64 -d)

kubectl run ef-postgresql-client --rm --tty -i --restart='Never' --namespace ef-external --image docker.io/bitnami/postgresql:14.5.0-debian-11-r21 --env="PGPASSWORD=$POSTGRES_PASSWORD" \
      --command -- psql --host ef-postgresql -U sa -d licenseManager -p 5432

If client pod is already created, then

CODE

kubectl -n ef-external exec -it ef-postgresql-client -- bash

# when entered into client pod, start PostgreSQL server 
psql --host ef-postgresql -U sa -d licenseManager -p 5432

Drop and re-create the database airflow

CODE

# Check if the database is available
\l

# Drop the database
DROP DATABASE airflow;

# Now re-create database
CREATE DATABASE airflow;

# Exit from the client pod
exit