pgpooladmin

Soucast docker-compose:

    pgpooladmin:
        build:
            context: ../src
            dockerfile: PgpoolAdmin-4.0-Postgres-10.Dockerfile
        environment:
            HOSTNAME: pgpooladmin
            PCP_USER: ${ENV_PCP_USER}
            PCP_PASSWORD: ${ENV_PCP_PASSWORD}
            WAIT_BACKEND_TIMEOUT: 60

            CHECK_USER: ${ENV_CHECK_USER}
            CHECK_PASSWORD: ${ENV_CHECK_PASSWORD}
            CHECK_PGCONNECT_TIMEOUT: 3 #timout for checking if primary node is healthy
            SSH_ENABLE: 1
            DB_USERS: ${ENV_CHECK_USER}:${ENV_CHECK_PASSWORD}
        ports:
                - 8080:80 # PCP
        volumes:
            - ./ssh:/home/postgres/.ssh/keys
        restart: always
        networks:
            cluster:
                aliases:
                    - pgpool



PgpoolAdmin-4.0-Postgres-10.Dockerfile:

FROM debian:jessie
ARG DOCKERIZE_VERSION=v0.2.0

# grab gosu for easy step-down from root
ARG GOSU_VERSION=1.7
RUN set -x \
        && apt-get update && apt-get install -y --no-install-recommends ca-certificates wget && rm -rf /var/lib/apt/lists/* \
        && wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$(dpkg --print-architecture)" \
        && wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$(dpkg --print-architecture).asc" \
        && export GNUPGHOME="$(mktemp -d)" \
        #echo "disable-ipv6" >> "$GNUPGHOME"/dirmngr.conf;
        && gpg --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4 \
        && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu \
        && rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc \
        && chmod +x /usr/local/bin/gosu \
        && gosu nobody true

RUN  wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | apt-key add - && \
     sh -c 'echo "deb http://ftp.de.debian.org/debian sid main" >> /etc/apt/sources.list.d/sid.list' && \
     sh -c 'echo "deb http://ftp.cz.debian.org/debian/ stable main contrib non-free" >> /etc/apt/sources.list.d/stable.list' && \
     apt-get update

RUN  apt-get install -y libffi-dev libssl-dev openssh-server apache2 php libapache2-mod-php php-mcrypt libssl1.1

RUN TEMP_TAR="$(mktemp)" && \
    TEMP_TAR_DIR="$(mktemp -d)" && \
    wget -O "$TEMP_TAR" "http://www.pgpool.net/download.php?f=pgpoolAdmin-4.0.1.tar.gz" && \
    tar zxvf $TEMP_TAR -C $TEMP_TAR_DIR && \
    mkdir -p /var/www/html/pgpooladmin && \
    mv $TEMP_TAR_DIR/*/* /var/www/html/pgpooladmin && \
    ls -l /var/www/html/pgpooladmin && \
    chown root:root -R /var/www/html/pgpooladmin && \
    chmod 0777 /var/www/html/pgpooladmin/templates_c && \
    chown www-data /var/www/html/pgpooladmin/conf/pgmgt.conf.php && \
    chmod 0644 /var/www/html/pgpooladmin/conf/pgmgt.conf.php

RUN  wget https://github.com/jwilder/dockerize/releases/download/$DOCKERIZE_VERSION/dockerize-linux-amd64-$DOCKERIZE_VERSION.tar.gz && \
     tar -C /usr/local/bin -xzvf dockerize-linux-amd64-$DOCKERIZE_VERSION.tar.gz

COPY ./ssh /home/postgres/.ssh

ENV SSH_ENABLE 1

COPY pgpooladmin/etc/apache2/sites-available/* /etc/apache2/sites-available/
RUN sh -c 'echo "ServerName pgpooladmin" >> /etc/apache2/apache2.conf'

RUN sh -c 'a2ensite pgpooladmin.conf'
COPY pgpooladmin/entrypoint.sh /

RUN sh -c 'chmod +x /entrypoint.sh'
EXPOSE 22
EXPOSE 80

CMD ["/entrypoint.sh"]