Re: PG_DUMPALL not executable within docker container

Thank you very much. Found the Key point here:

*Current Setup:*synesc(at)dockerhost01:~/$ lsb_release -a
No LSB modules are available.
Distributor ID:
Ubuntu Description: Ubuntu 20.04.4 LTS
Release: 20.04
Codename: focal
synesc(at)dockerhost01:~/$ docker --version
Docker version 20.10.0, build 7287ab3

Issue exists with docker image *postgres:15.4*

PG_DUMPALL
postgres | popen failure: Cannot allocate memory
postgres | pg_dumpall: error: program "pg_dump" is needed by pg_dumpall
but was not found in the same directory as
"/usr/lib/postgresql/15/bin/pg_dumpall"

STARTUP/INITDB
postgres | popen failure: Cannot allocate memory
postgres | initdb: error: program "postgres" is needed by initdb but was
not found in the same directory as "/usr/lib/postgresql/15/bin/initdb"

*Different Setup:*
master(at)dockerhost:~/$ lsb_release -a
No LSB modules are available.
Distributor ID:
Ubuntu Description: Ubuntu 22.04.3 LTS
Release: 22.04
Codename: jammy
master(at)dockerhost:~/$ docker --version
Docker version 24.0.6, build ed223bc

On this different (newer) setup the issues do not exist.

*Solution*
Use appropriate docker-image.
https://askubuntu.com/questions/445487/what-debian-version-are-the-different-ubuntu-versions-based-on

version | ubuntu | debian
22.04 | jammy | bookworm/ sid
20.04 | focal | bullseye/ sid

With the docker-image *postgres:15.4-bullseye* it does work on the Ubuntu
20.04 setup.
Not really happy with the behaviour. Would suggest to add a note to
docker-hub description what image to pick.

--
Ing. Frießnegg Patrick
Synesc GmbH
mailto: patrick(dot)fri(at)gmail(dot)com