FROM php:8.2-apache

# Install PostgreSQL client libraries and PHP pdo_pgsql extension
RUN apt-get update && apt-get install -y \
    libpq-dev \
    && docker-php-ext-install pdo pdo_pgsql \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*

# Enable Apache Mod Rewrite
RUN a2enmod rewrite