tommi2day/postgresql-debugger repository overview

⁠Postgresql PL/pg Docker Images

This runs on top of the official Postgres image⁠, configure SSL and compiles and configure the pldebugger and adds extra extensions:

• pgaudit
• pg_stat_statements
• pldbgapi
• passwordpolicy

⁠CREDITS

based on Dockerfile and scripts provided on https://github.com/ng-galien/idea-plpgdebugger/tree/233/docker⁠

⁠build

PG_IMAGE=postgresql-debugger
DISTRO=bookworm
DOCKER_USER=tommi2day
PG_VERSION=16
docker build --build-arg "VERSION=${PG_VERSION}" --build-arg "DISTRO=${DISTRO}" --build-arg "INITDB=./initdb" -t "$DOCKER_USER/$PG_IMAGE:${PG_VERSION}" .

This will create Images for Postgresql 6 and init scripts in ./initdb. see build_all_local.sh⁠.

if you like to install non-default extension packages (such as pgaudit), add them to the extra_packages.lst file similar. ${VERSION} will be replaced by the build argument. Dont forget to add your create extension statement to the init files (see below)

⁠use

Use it the same way as the official PostgreSQL image, but use this one. You may add more init scripts to the initdb folder, which will copied to /docker-entrypoint-initdb.d/

# simple run
docker run -p 5514:5432 --name PG16-debug -e POSTGRES_PASSWORD=postgres -d tommi2day/postgresql-debugger:16

a more complete example incl. SSL, persistent data and alternative init you can find in run_local.sh⁠

⁠see also

• Source Repo⁠
• IntelliJ PL/pg SQL Debugger⁠ Repo
• Intellij Plugin Page⁠
• Original Images: galien0xffffff/postgres-debugger docker⁠