如何使用Docker安装PostgreSQL扩展

您缺少安装的clang-11包，我添加了这个包和postgresql-server-dev-14也:

Dockerfile_gzip

FROM postgres:14.0

ENV DEBIAN_FRONTEND=noninteractive

RUN apt-get update && \
    apt-get install -y \
        build-essential \
        zlib1g-dev \       
        pkg-config \
        git \
        mc \
        postgresql-server-dev-14 \ 
        clang-11

RUN git clone https://github.com/pramsey/pgsql-gzip.git \
    && cd pgsql-gzip \
    && make \
    && make install

docker-compose up -d个commad使用这个docker-compose文件:

version: "3"

services:
    pg14:
        build: 
            context: .
            dockerfile: Dockerfile_gzip
        container_name: pg14-gzip
        ports:
            - 15566:5432
        env_file: pgsecrets.env

pgsecrets.env行文件

POSTGRES_PASSWORD=postgres
POSTGRES_USER=postgres
POSTGRES_INITDB_ARGS="-A trust"

我能够创建扩展

docker exec -it pg14-gzip bash
root@98ceed5151c0:/# su - postgres
postgres@98ceed5151c0:~$ psql
psql (14.0 (Debian 14.0-1.pgdg110+1))
Type "help" for help.

postgres=# create extension gzip ;
CREATE EXTENSION
postgres=# \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description          
---------+---------+------------+------------------------------
 gzip    | 1.0     | public     | gzip and gunzip functions.
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

postgres=#