docker-library / postgres

Docker Official Image packaging for Postgres
http://www.postgresql.org
MIT License
2.19k stars 1.14k forks source link

plperl is not in version 15 #1066

Closed manicar2093 closed 1 year ago

manicar2093 commented 1 year ago

Hi!

I'm trying to set a posrgres docker image to use plpearl but it seems this extension does not exists now. I found this PR where plpearl was added in version 9.

The question is: Is there a way to install this extension in a running container?

Thanks!

ImreSamu commented 1 year ago

The question is: Is there a way to install this extension in a running container?

imho: the recommended way: extending the image example Dockerfile:

FROM postgres:15-bullseye
RUN apt-get update \
      && apt-get install -y --no-install-recommends  \
         postgresql-plperl-15 \
      && rm -rf /var/lib/apt/lists/*

see: https://github.com/docker-library/docs/tree/master/postgres#additional-extensions -> "Additional Extensions"

manicar2093 commented 1 year ago

@ImreSamu Thanks! That's what I did and it works!