Dockerfile_postgres_15_Jenkins

#
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

FROM ubuntu:22.04

# Argument for configuring the timezone
ARG TIMEZONE_VAR="Europe/London"
ENV TZ=${TIMEZONE_VAR}
ENV DEBIAN_FRONTEND=noninteractive

# Set the LOCALE
ENV LANG=en_US.UTF-8
RUN apt-get update && apt-get install -y locales && \
                        locale-gen en_US.UTF-8 && \
                        update-locale LANG=en_US.UTF-8 && \
                        apt-get clean && rm -rf /var/lib/apt/lists/*

### Get postgres specific add-ons
RUN apt-get update && apt-get install -y wget \
                        build-essential \
                        openssl \
                        libssl-dev \
                        lsb-release \
                        libboost-all-dev \
                        m4 \
                        rpm \
                        python3-pip \
                        python3-dev \
                        cmake \
                        libspatialindex-dev \
                        vim \
                        sudo \
                        software-properties-common \
                        lsb-core \
                        libyaml-dev \
                        libpython3-dev \
                        python3-distutils \
                        iputils-ping \
                        iproute2 \
                        net-tools \
                        ca-certificates && \
                        apt-get clean && rm -rf /var/lib/apt/lists/*

RUN add-apt-repository -y ppa:deadsnakes/ppa
RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list

RUN wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
RUN apt-get update && apt-get install -y \
                        postgresql-server-dev-15 \
                        postgresql-plpython3-15 \
                        postgresql-15 \
                        postgresql-client-15 \
                        libpq-dev && \
                        apt-get clean && rm -rf /var/lib/apt/lists/*
RUN update-alternatives --install /usr/bin/python python /usr/bin/python3 1
RUN python3 -m pip install dill rtree xgboost mock pandas numpy scikit-learn pyxb-x

## To build an image from this docker file, from madlib folder, run:
# docker build -t madlib/postgres_15:jenkins -f tool/docker/base/Dockerfile_postgres_15_Jenkins .