# Use the latest Ubuntu image as the base
FROM ubuntu:latest

# Install necessary packages  
RUN apt-get update && apt-get install -y \  
    curl \
    wget \
    unzip \
    git \
    python3-pip \
    libmagic-dev \
    lsb-release \
    lsof \
    postgresql \
    gnupg

# Install the PostgreSQL 16 repository key
RUN curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg

# Install PostgreSQL 16 client
RUN apt-get update && apt-get install -y postgresql-client-16

# Copy the entrypoint script to the container
COPY entrypoint.sh /usr/local/bin/
RUN chmod +x /usr/local/bin/entrypoint.sh

# Expose the default PostgreSQL port
EXPOSE 5432

# Set the ENTRYPOINT to the entrypoint script
ENTRYPOINT ["/usr/local/bin/entrypoint.sh"]