connect to a postgres instance behind kubectl

pgctl

#!/bin/bash -eux

CONTEXT=pro
APP=purple

exec 3< <(
    pgid=$!
    echo "kill $pgid"
    kubectl --context=${CONTEXT} --namespace=${APP} port-forward ${APP}-${APP}-db-0 :5432
    )

while true; do 
    read <&3 line; 
    if [[ $line == *"kill"* ]]; then
        killLine=$line
        killJob() {
            echo "cleaning up ${killLine}"
            ${killLine}
        }
        trap killJob EXIT SIGINT
    fi

    if [[ $line == *"Forwarding from 127.0.0.1"* ]]; then
        port=$(echo "$line" | cut -d : -f 2 | cut -d ' ' -f 1)

        PGOPTIONS="-c search_path=${APP}" psql -h localhost -p ${port} -d ${APP}
        
        exit
    fi
done