FROM postgres:15-trixie

# 创建日志目录并设置权限
USER root
RUN mkdir -p /var/log/deepdata/database && \
    chown -R postgres:postgres /var/log/deepdata && \
    chmod -R 755 /var/log/deepdata

ENV POSTGRES_INITDB_ARGS="--encoding=UTF8 --lc-collate=en_US.UTF-8 --lc-ctype=en_US.UTF-8"
# 创建配置目录
RUN mkdir -p /etc/postgresql/
# 复制 PostgreSQL 主配置文件
COPY scripts/images/database/postgresql.cnf /etc/postgresql/postgresql.conf
COPY scripts/images/database/prune-postgres-logs.sh /usr/local/bin/prune-postgres-logs.sh
COPY scripts/images/database/start.sh /usr/local/bin/deepdata-database-start.sh

COPY scripts/db/ /docker-entrypoint-initdb.d/

RUN chmod +x /usr/local/bin/prune-postgres-logs.sh /usr/local/bin/deepdata-database-start.sh

ENTRYPOINT ["/usr/local/bin/deepdata-database-start.sh"]
CMD ["postgres", "-c", "config_file=/etc/postgresql/postgresql.conf"]