Re: PG_DUMPALL not executable within docker container

Поиск
Список
Период
Сортировка
От Patrick Frießnegg
Тема Re: PG_DUMPALL not executable within docker container
Дата
Msg-id CAApuS=_Hf72Uo26F3fEX4ArG+UwkxRp8fnZHMm94H063a8KqCw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG_DUMPALL not executable within docker container  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-bugs
Thank you very much. Found the Key point here:

Current Setup:
synesc@dockerhost01:~/$ lsb_release -a
No LSB modules are available.
Distributor ID:
Ubuntu Description: Ubuntu 20.04.4 LTS
Release: 20.04
Codename: focal
synesc@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@dockerhost:~/$ lsb_release -a
No LSB modules are available.
Distributor ID:
Ubuntu Description: Ubuntu 22.04.3 LTS
Release: 22.04
Codename: jammy
master@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.fri@gmail.com

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Zhaoxun Yan
Дата:
Сообщение: pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18135: Incorrect memory access occurs when attaching a partition with an index