#!/bin/bash
set -e

POSTGRES_VERSION="${POSTGRES_VERSION:-16}"
POSTGRES_DATA_DIR="${POSTGRES_DATA_DIR:-/data/postgres}"
POSTGRES_PORT="${POSTGRES_PORT:-5432}"
POSTGRES_USER="${POSTGRES_USER:-vibestack}"
POSTGRES_PASSWORD="${POSTGRES_PASSWORD:-vibestack}"
POSTGRES_DB="${POSTGRES_DB:-vibestack}"

# Export DATABASE_URL for other services
export DATABASE_URL="postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@localhost:${POSTGRES_PORT}/${POSTGRES_DB}"
echo "DATABASE_URL=$DATABASE_URL"

# Write to shared env file for other skills
mkdir -p /run/vibestack
echo "DATABASE_URL=$DATABASE_URL" > /run/vibestack/postgres.env

echo "Starting PostgreSQL on port $POSTGRES_PORT..."
exec su - postgres -c "/usr/lib/postgresql/${POSTGRES_VERSION}/bin/postgres -D '$POSTGRES_DATA_DIR'"