2023-02-09 03:58:40 UTC

/bin/sh -c #(nop) ADD file:3276ac85bb957360f20720da5b37498a6b5f91a017046049f8d2fd791f728a9a in /

2023-02-09 03:58:40 UTC

/bin/sh -c #(nop) CMD ["bash"]

2023-02-09 06:46:01 UTC

/bin/sh -c set -ex; if ! command -v gpg > /dev/null; then apt-get update; apt-get install -y --no-install-recommends gnupg dirmngr ; rm -rf /var/lib/apt/lists/*; fi

2023-02-09 06:46:01 UTC

/bin/sh -c set -eux; groupadd -r postgres --gid=999; useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql

2023-02-09 06:46:02 UTC

/bin/sh -c #(nop) ENV GOSU_VERSION=1.16

2023-02-09 06:46:10 UTC

/bin/sh -c set -eux; savedAptMark="$(apt-mark showmanual)"; apt-get update; apt-get install -y --no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf --kill all; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; apt-mark auto '.*' > /dev/null; [ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true

2023-02-09 06:46:15 UTC

/bin/sh -c set -eux; if [ -f /etc/dpkg/dpkg.cfg.d/docker ]; then grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; sed -ri '/\/usr\/share\/locale/d' /etc/dpkg/dpkg.cfg.d/docker; ! grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; fi; apt-get update; apt-get install -y --no-install-recommends locales; rm -rf /var/lib/apt/lists/*; localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8

2023-02-09 06:46:15 UTC

/bin/sh -c #(nop) ENV LANG=en_US.utf8

2023-02-09 06:46:18 UTC

/bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends libnss-wrapper xz-utils zstd ; rm -rf /var/lib/apt/lists/*

2023-02-09 06:46:19 UTC

/bin/sh -c mkdir /docker-entrypoint-initdb.d

2023-02-09 06:46:20 UTC

/bin/sh -c set -ex; key='B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8'; export GNUPGHOME="$(mktemp -d)"; mkdir -p /usr/local/share/keyrings/; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /usr/local/share/keyrings/postgres.gpg.asc; command -v gpgconf > /dev/null && gpgconf --kill all; rm -rf "$GNUPGHOME"

2023-02-09 06:46:20 UTC

/bin/sh -c #(nop) ENV PG_MAJOR=15

2023-02-09 06:46:20 UTC

/bin/sh -c #(nop) ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/15/bin

2023-02-09 06:46:20 UTC

/bin/sh -c #(nop) ENV PG_VERSION=15.1-1.pgdg110+1

2023-02-09 06:46:38 UTC

/bin/sh -c set -ex; export PYTHONDONTWRITEBYTECODE=1; dpkgArch="$(dpkg --print-architecture)"; aptRepo="[ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main $PG_MAJOR"; case "$dpkgArch" in amd64 | arm64 | ppc64el) echo "deb $aptRepo" > /etc/apt/sources.list.d/pgdg.list; apt-get update; ;; *) echo "deb-src $aptRepo" > /etc/apt/sources.list.d/pgdg.list; savedAptMark="$(apt-mark showmanual)"; tempDir="$(mktemp -d)"; cd "$tempDir"; apt-get update; apt-get install -y --no-install-recommends dpkg-dev; echo "deb [ trusted=yes ] file://$tempDir ./" > /etc/apt/sources.list.d/temp.list; _update_repo() { dpkg-scanpackages . > Packages; apt-get -o Acquire::GzipIndexes=false update; }; _update_repo; nproc="$(nproc)"; export DEB_BUILD_OPTIONS="nocheck parallel=$nproc"; apt-get build-dep -y postgresql-common pgdg-keyring; apt-get source --compile postgresql-common pgdg-keyring; _update_repo; apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; apt-mark showmanual | xargs apt-mark auto > /dev/null; apt-mark manual $savedAptMark; ls -lAFh; _update_repo; grep '^Package: ' Packages; cd /; ;; esac; apt-get install -y --no-install-recommends postgresql-common; sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf; apt-get install -y --no-install-recommends "postgresql-$PG_MAJOR=$PG_VERSION" ; rm -rf /var/lib/apt/lists/*; if [ -n "$tempDir" ]; then apt-get purge -y --auto-remove; rm -rf "$tempDir" /etc/apt/sources.list.d/temp.list; fi; find /usr -name '*.pyc' -type f -exec bash -c 'for pyc; do dpkg -S "$pyc" &> /dev/null || rm -vf "$pyc"; done' -- '{}' +; postgres --version

2023-02-09 06:46:39 UTC

/bin/sh -c set -eux; dpkg-divert --add --rename --divert "/usr/share/postgresql/postgresql.conf.sample.dpkg" "/usr/share/postgresql/$PG_MAJOR/postgresql.conf.sample"; cp -v /usr/share/postgresql/postgresql.conf.sample.dpkg /usr/share/postgresql/postgresql.conf.sample; ln -sv ../postgresql.conf.sample "/usr/share/postgresql/$PG_MAJOR/"; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/share/postgresql/postgresql.conf.sample

2023-02-09 06:46:40 UTC

/bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 2777 /var/run/postgresql

2023-02-09 06:46:40 UTC

/bin/sh -c #(nop) ENV PGDATA=/var/lib/postgresql/data

2023-02-09 06:46:40 UTC

/bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 777 "$PGDATA"

2023-02-09 06:46:40 UTC

/bin/sh -c #(nop) VOLUME [/var/lib/postgresql/data]

2023-02-09 06:46:40 UTC

/bin/sh -c #(nop) COPY file:d4c2ceee202d1390df115217c6e567abc1da7a31572f20a840d966332148ebe4 in /usr/local/bin/

2023-02-09 06:46:41 UTC

/bin/sh -c #(nop) ENTRYPOINT ["docker-entrypoint.sh"]

2023-02-09 06:46:41 UTC

/bin/sh -c #(nop) STOPSIGNAL SIGINT

2023-02-09 06:46:41 UTC

/bin/sh -c #(nop) EXPOSE 5432

2023-02-09 06:46:41 UTC

/bin/sh -c #(nop) CMD ["postgres"]

2023-03-30 14:01:08 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2023-03-30 14:01:08 UTC (buildkit.dockerfile.v0)

ARG postgresql_major

2023-03-30 14:01:08 UTC (buildkit.dockerfile.v0)

COPY /tmp /tmp # buildkit

2023-03-30 14:01:08 UTC (buildkit.dockerfile.v0)

ENV DEBIAN_FRONTEND=noninteractive

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends /tmp/*.deb ca-certificates && rm -rf /var/lib/apt/lists/* /tmp/* # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit

2023-03-30 14:01:54 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/15/bin/pgsodium_getkey.sh # buildkit

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i "s/#unix_socket_directories = '\/tmp'/unix_socket_directories = '\/var\/run\/postgresql'/g" /etc/postgresql/postgresql.conf && sed -i "s/#session_preload_libraries = ''/session_preload_libraries = 'supautils'/g" /etc/postgresql/postgresql.conf && sed -i "s/#include = '\/etc\/postgresql-custom\/supautils.conf'/include = '\/etc\/postgresql-custom\/supautils.conf'/g" /etc/postgresql/postgresql.conf && echo "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pljava.libjvm_location = '/usr/lib/jvm/java-11-openjdk-${TARGETARCH}/lib/server/libjvm.so'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/${postgresql_major}/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_INITDB_ARGS=--lc-ctype=C.UTF-8

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

CMD ["postgres" "-D" "/etc/postgresql"]

2023-03-30 14:01:55 UTC (buildkit.dockerfile.v0)

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" '\n'}