# syntax = docker/dockerfile:1.3-labs

# Base PostgreSQL debug image, where we compile and install it from source with

# full debugging capabilities. For more details see:

# https://wiki.postgresql.org/wiki/Developer_FAQ#Compile-time

# Note that we use the pre-built PG image from:

# https://github.com/docker-library/postgres/blob/master/12/bullseye/Dockerfile

# and just swap out the binaries and shared libs with the ones installed below.

#####

##### toolchain

#####

FROM postgres:12.3

# Compile and install PG in debug mode

ARG use_valgrind

RUN rm -rf /usr/lib/postgresql/12/* && \

apt-get update -qq && \

apt-get install -y --allow-downgrades \

build-essential \

curl \

wget \

git \

vim \

libssl-dev \

libsasl2-dev \

pkgconf \

autoconf \

libtool \

# https://github.com/docker-library/postgres/issues/678#issuecomment-586888013

postgresql-server-dev-$PG_MAJOR \

protobuf-c-compiler \

libprotobuf-c-dev \

libpython3.7-dev \

python3.7 \

python3-setuptools \

cmake \

clang-7 \

# Debugging tools

sudo \

gdb \

procps \

# PG source installation reqs

bison \

flex \

build-essential \

libreadline-dev \

libffi6-dbg \

libgcc1-dbg \

libkrb5-dbg \

libstdc++6-8-dbg \

libxml2-dbg \

zlib1g-dbg \

zlib1g \

zlib1g-dev \

xsltproc \

libxml2-utils && \

rm -rf /var/lib/apt/lists/* && \

# pgprint command for GDB

git clone https://github.com/tvesely/gdbpg.git && \

# Download PG source

git clone -b REL_12_STABLE https://github.com/postgres/postgres.git && \

# Download Valgrind source, compile and install

test -z "${use_valgrind}" || (\

# Make a switcheroo in the image entrypoint, so that instead of starting plain

# postgres we start it under Valgrind

sed -i -e 's/"$BASH_SOURCE"/"$BASH_SOURCE" valgrind --leak-check=full --show-leak-kinds=definite,indirect \

--num-callers=25 --log-file=\/pg-valgrind\/valgrind-%p.log --trace-children=yes \

--gen-suppressions=all --suppressions=postgres\/src\/tools\/valgrind.supp \

--suppressions=valgrind-python.supp --verbose --time-stamp=yes \

--error-markers=VALGRINDERROR-BEGIN,VALGRINDERROR-END/' /usr/local/bin/docker-entrypoint.sh && \

# Configure PG with Valgrind support

sed -i -e 's=/\*\s#define\sUSE_VALGRIND\s\*/=#define USE_VALGRIND=' postgres/src/include/pg_config_manual.h && \

# Download Python Valgrind suppressions and make folder for output files

curl https://svn.python.org/projects/python/trunk/Misc/valgrind-python.supp --output valgrind-python.supp && \

mkdir -p /pg-valgrind && sudo chmod a+w /pg-valgrind && \

# Build Valgrind

curl https://sourceware.org/pub/valgrind/valgrind-3.18.1.tar.bz2 --output valgrind-3.18.1.tar.bz2 && \

tar xf valgrind-3.18.1.tar.bz2 && \

cd valgrind-3.18.1 && \

./configure && \

make && \

make install && \

cd ..) && \

# Compile and install PG from source

cd /postgres && \

mkdir -p /usr/lib/postgresql/12 && \

./configure \

--enable-cassert \

--enable-debug \

CFLAGS="-ggdb -Og -g3 -fno-omit-frame-pointer" \

-prefix=/usr/lib/postgresql/12 && \

make && \

make install

# Extensions are not installed automatically; install extensions so that

# we can step through them in GDB (but otherwise they work fine without this).

# cd contrib && \

# make all && \

# make install

# Configure GDB: enable pgprint, disable confirmation and dynamic load prompt

COPY <<EOF /etc/gdb/gdbinit

source /gdbpg/gdbpg.py

set confirm off

set breakpoint pending on

EOF