#!/bin/bash
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    -- Configurar zona horaria Atlantic/Canary
    ALTER DATABASE "$POSTGRES_DB" SET timezone TO 'Atlantic/Canary';
    ALTER ROLE "$POSTGRES_USER" SET timezone TO 'Atlantic/Canary';
    
    -- Verificar que la base de datos existe
    SELECT 'Database is ready!' as status;
    
    -- Crear extensiones si son necesarias
    CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
    
    -- Mostrar zona horaria configurada
    SHOW timezone;
EOSQL

echo "Database initialization completed successfully with timezone: Atlantic/Canary"