Connect to PostgreSQL database
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
Drop and re-create the database airflow
# 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