deepseek/deepseek-v4-pro · d2_pooling · rep 3

echo "SUPABASE_URL=$SUPABASE_URL"
echo "SUPABASE_PROJECT_REF=$SUPABASE_PROJECT_REF"
echo "SUPABASE_DB_URL=$SUPABASE_DB_URL" | sed 's/:[^:@]*@/:***@/'
echo "DB_PASSWORD_SET=$([ -n "$SUPABASE_DB_PASSWORD" ] && echo yes || echo no)"

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_PROJECT_REF=<ref>
SUPABASE_DB_URL=postgresql://postgres.<ref>:***@aws-0-us-east-1.pooler.supabase.com:5432/postgres
DB_PASSWORD_SET=yes

which psql && psql --version

/usr/bin/psql
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

# Test transaction-mode pooler connection on port 6543
PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "postgresql://postgres.${SUPABASE_PROJECT_REF}@aws-0-us-east-1.pooler.supabase.com:6543/postgres" -c "SELECT pg_backend_pid();" 2>&1

 pg_backend_pid 
----------------
          15078
(1 row)

cat > pool_smoke.sh << 'SCRIPT'
#!/usr/bin/env bash
set -euo pipefail

# ---- validate environment ----
: "${SUPABASE_DB_PASSWORD:?SUPABASE_DB_PASSWORD must be set}"
: "${SUPABASE_PROJECT_REF:?SUPABASE_PROJECT_REF must be set}"

# ---- transaction-mode pooler: port 6543 ----
readonly TX_HOST="aws-0-us-east-1.pooler.supabase.com"
readonly TX_PORT=6543
readonly TX_USER="postgres.${SUPABASE_PROJECT_REF}"
readonly TX_DB="postgres"

readonly CONNSTR="postgresql://${TX_USER}@${TX_HOST}:${TX_PORT}/${TX_DB}"

readonly CONCURRENCY=20
readonly TMPDIR=$(mktemp -d)
trap 'rm -rf "$TMPDIR"' EXIT

# ---- launch 20 concurrent queries ----
for i in $(seq 1 "$CONCURRENCY"); do
  (
    result=$(PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$CONNSTR" \
      --no-align --tuples-only \
      -c "SELECT pg_backend_pid();" 2>&1) && \
      echo "ok" || echo "fail: $result"
  ) > "$TMPDIR/result_$i" &
done

wait

# ---- tally ----
ok=0
for f in "$TMPDIR"/result_*; do
  if grep -q '^ok$' "$f"; then
    ok=$((ok + 1))
  else
    echo "FAIL: $(cat "$f")" >&2
  fi
done

if [ "$ok" -eq "$CONCURRENCY" ]; then
  echo "POOL OK ${ok}/${CONCURRENCY}"
  exit 0
else
  echo "POOL FAIL ${ok}/${CONCURRENCY}" >&2
  exit 1
fi
SCRIPT

chmod +x pool_smoke.sh

./pool_smoke.sh

POOL OK 20/20

# Unset password, confirm it fails fast
(unset SUPABASE_DB_PASSWORD; ./pool_smoke.sh 2>&1; echo "exit=$?")

./pool_smoke.sh: line 5: SUPABASE_DB_PASSWORD: SUPABASE_DB_PASSWORD must be set
exit=1

grep -n 'SUPABASE_DB_PASSWORD\|password' pool_smoke.sh

5:: "${SUPABASE_DB_PASSWORD:?SUPABASE_DB_PASSWORD must be set}"
23:    result=$(PGPASSWORD="$SUPABASE_DB_PASSWORD" psql "$CONNSTR" \