docker-library / docker-library/postgres

LZ4 is configured during compilation, but not available when querying the docker container

Open
#1,191 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Shell
Stars
2.5k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

Hello,

I am using the 16-alpine image for a docker container. I am using alpine specifically because lz4 appears to be enabled during compilation of the docker image. However, when I connect to the docker container and write SQL that depends on lz4 I get this error:

ERROR:  compression method lz4 not supported
DETAIL:  This functionality requires the server to be built with lz4 support.
HINT:  You need to rebuild PostgreSQL using --with-lz4.
SQL state: 0A000

However, in the dockerfile, LZ4 compression is enabled
https://github.com/docker-library/postgres/blob/ce5bf6e7eb8f339b2a8561bf8fb5fe5d4e8c96aa/16/alpine3.19/Dockerfile#L124

Here is an example SQL query I am trying to run:

CREATE TABLE my_table (
    ...
    id bigint GENERATED ALWAYS AS IDENTITY,
    data text COMPRESSION lz4,
    ...
);

Is there some additional configuration I need to pass into the docker container?
Here is a snippet of the docker-compose

postgres:
    image: postgres:16-alpine
    container_name: my_postgres
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: postgres
    volumes:
      - type: bind
        source: ../..
        target: /my_dir
    ports:
      - "5432:5432"

I have also downgraded and tried with 15.5-alpine.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Inspect 16-alpine3.19/Dockerfile around line 124, then reproduce the CREATE TABLE statement in the postgres:16-alpine container using the shown docker-compose configuration. Compare the image's build configuration with the running server's reported compression capabilities. Done means identifying whether the image or runtime setup prevents LZ4 support and documenting the required change.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, postgres, shell
Domain
databases, devops
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.