Troubleshooting Expertflow ETL Data Platform

Connect to PostgreSQL database

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

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