Files
ca/sql/trustycadb/wait_sql.sh
2026-09-07 17:12:04 +01:00

27 lines
627 B
Bash
Executable File

#!/bin/bash
set -e
POSTGRES_HOST="$1"
POSTGRES_PORT="$2"
POSTGRES_USER="$3"
POSTGRES_PWD="$4"
shift # past host
shift # past port
shift # past user
shift # past pwd
cmd="$@"
echo "*** sql: waiting on trustycadb..."
sleep 3
until PGPASSWORD=$POSTGRES_PWD psql -h $POSTGRES_HOST -p $POSTGRES_PORT -U $POSTGRES_USER -lqt | cut -d \| -f 1 | grep -qw postgres; do
>&2 echo "trustycadb is unavailable $POSTGRES_HOST:$POSTGRES_PORT - sleeping"
>&2 PGPASSWORD=$POSTGRES_PWD psql -h $POSTGRES_HOST -p $POSTGRES_PORT -U $POSTGRES_USER -lqt
sleep 3
done
>&2 echo "trustycadb is up - executing command:"
>&2 echo $cmd
exec $cmd