Docker PostgreSQL 9.6-安装扩展plpython3u（与分位数扩展冲突）

Question

我正试图安装一个PostgreSQL docker化服务，与plpython。我能够成功地构建映像，但是当我来运行容器时，我得到以下错误：

错误：无法打开扩展控制文件"/usr/share/postgresql/9.5/扩展/plpython3u.control"：没有这样的文件或目录声明：创建扩展"plpython3u"； psql：/docker-entrypoint-initdb. d/create_db.sql： 7：错误：无法打开扩展控制文件"/usr/share/postgresql/9.5/扩展名/plpython3u.control"：没有这样的文件或目录

me@yourbox:~/Projects/experimental/docker/scratchdb$ tree
.
├── Dockerfile
└── sql
    ├── create_db.sql
    └── schemas
        └── DDL
            └── db_schema_foo.sql

FROM library/postgres:9.6
FROM zitsen/postgres-pgxn

RUN apt-get update \
 && apt-get install -y --no-install-recommends \
    python3 postgresql-plpython3-9.6

RUN pgxn install quantile

COPY sql /docker-entrypoint-initdb.d/ 

# Add VOLUMEs to allow backup of config, logs and databases
VOLUME  ["/etc/postgresql", "/var/log/postgresql", "/var/lib/postgresql"]

# Set the default command to run when starting the container
# CMD ["/usr/lib/postgresql/9.6/bin/postgres", "-D", "/var/lib/postgresql/9.6/main", "-c", "config_file=/etc/postgresql/9.6/main/postgresql.conf"]

# Uncomment line below for debugging purposes
set client_min_messages TO debug1;

CREATE EXTENSION "quantile"
CREATE EXTENSION "plpython3u";

-- Create myappuser
CREATE ROLE myappuser LOGIN ENCRYPTED PASSWORD 'passw0rd123' NOINHERIT;
CREATE DATABASE only_foo_and_horses WITH ENCODING 'UTF8' TEMPLATE template1;
-- \l+
GRANT ALL PRIVILEGES ON DATABASE only_foo_and_horses TO myappuser;

-- Import only_foo_and_horses DDL and initialise database data
\c only_foo_and_horses;
\i /docker-entrypoint-initdb.d/schemas/DDL/db_schema_foo.sql;



-- # enable python in database

[[编辑]]

以下是我用于构建和运行容器的命令：

docker build -t scratch:pg .
docker run -it -rm scratch:pg

如何在停靠的PostgreSQL服务中安装plpython？

Answer 1

我刚刚从头开始运行了这一切，似乎扩展已经成功创建。还有问题吗？

/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/create_db.sql
SET
CREATE EXTENSION
CREATE ROLE
CREATE DATABASE
GRANT


LOG:  received fast shutdown request
waiting for server to shut down...LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
.LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

Answer 2

我认为您的错误是因为初始错误的CMD，它指向了该图像的PostgreSQL错误位置（9.5 vs 9.6）。

但是，我认为我已经发现了为什么不导入SQL的错误。

此图像的默认入口点（位于https://github.com/docker-library/postgres/blob/bef8f02d1fe2bb4547280ba609f19abd20230180/9.6/docker-entrypoint.sh)负责从/docker entrypoint initdb导入。d/。由于您正在覆盖CMD，并且它不等同于postgresql，因此它将跳过此部分。

默认的ENTRYPOINT应该执行您想要的操作。尝试删除CMD。