jbc.lol
unoffical wafrn mirror
wafrn.net
atproto
social-network
activitypub
1FROM postgres:17
2
3RUN apt update && apt install postgresql-plpython3-17 -y && rm -rf /var/lib/apt/lists/*
4
5COPY pgwatch.sql /pgwatch.sql
6# COPY updateConfig.sh /docker-entrypoint-initdb.d/_updateConfig.sh
7
8
9HEALTHCHECK --interval=10s --timeout=5s --start-period=5s --retries=5 CMD cat /initialised.txt && pg_isready -U $POSTGRES_USER -d postgres
10
11ENTRYPOINT ["/bin/bash","-c","docker-entrypoint.sh postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c track_io_timing=on & \n rm -f /initialised.txt || true && \n until pg_isready -U $POSTGRES_USER -d postgres; do sleep 3; done && \n psql -U $POSTGRES_USER -d postgres -c \"CREATE ROLE $POSTGRES_METRICS_USER WITH LOGIN PASSWORD '$POSTGRES_METRICS_PASSWORD'\" || true && \n psql -U $POSTGRES_USER -d postgres -c \"CREATE DATABASE $POSTGRES_METRICS_DBNAME OWNER $POSTGRES_METRICS_USER\" || true && \n cat /pgwatch.sql | psql -U $POSTGRES_USER -d postgres || true && \n cat /pgwatch.sql | psql -U $POSTGRES_USER -d $POSTGRES_DB || true && \n cat /pgwatch.sql | psql -U $POSTGRES_USER -d $POSTGRES_METRICS_DBNAME || true && \n echo done > /initialised.txt && \n wait"]