Installing Postgres driver in php7-fpm Docker container

Question

I've installed PHP:latest Docker container using the docker-compose command. It installed php-7.1.6-fpm in my Docker. When I tried to install php7-pgsql extension it failed to find that package, instead found pdo and pdo_pgsql packages. That will not satisfy my need. When I search for the available packages in the installed PHP container, I could not find any related pgsql packages for php7, instead, I saw php5-pgsql package, that will not work with php7-fpm.

Finally, I installed php-5.6-fpm container after removing the old one targeting to use php5-pgsql package. But now I disappointed again that I could not find php5-pgsql package in the newly installed container.

I know I'll be missing some important points. Whether Alpine Linux does not have php-pgsql extension. What are the possible ways to include this extension in my PHP container. I've also included Nginx and Postgres in my docker-compose.yml

I've only 3-day theory knowledge in Docker and first-day practical experience.

Thanks for reading.

github.com/docker-library/php/issues/348 it works when we run it inside the container, but Dockerfile is not working. couldn't find the reason — Sony George
– Sony George, Commented Jul 8, 2017 at 10:40

Ruli · Accepted Answer · 2021-01-11 13:10:33Z

25

I ran into the same issue when I was settings up a new project to use pgsql.

I am using php7, so you should be able to use it as well. On your Dockerfile ensure you're covering the following steps.

Ensure you have the dependencies installed:

RUN apt-get update && apt-get install -y libpq-dev

Configure the extension:

RUN docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql

Install the extension:

RUN docker-php-ext-install pdo pdo_pgsql

edited Jan 11, 2021 at 13:10

Ruli

2,83113 gold badges36 silver badges48 bronze badges

answered Jul 23, 2017 at 11:13

Bernardo Silva

9609 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kamil Latosinski Over a year ago

What exactly does configuring do and why is it necessary?

andymel Over a year ago

I had to add pgsql to the last code line to make it work => RUN docker-php-ext-install pdo pdo_pgsql pgsql

Devon Ray · Accepted Answer · 2020-11-25 19:56:12Z

5

This is an old question i know, but i ran into this today and believe the above solution has changed with php:7.4-fpm-alpine

So where it used to be:

RUN apt-get update && apt-get install -y libpq-dev

Should now be:

RUN apt-get update && apt-get install -y postgresql-dev

Hopefully this helps anyone that runs into the same issue.

answered Nov 25, 2020 at 19:56

Devon Ray

8758 silver badges16 bronze badges

1 Comment

bcag2 Over a year ago

in my case in php-fpm-alpine, I

RUN apk … postgresql-dev && docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \     && docker-php-ext-install pdo pdo_pgsql pgsql

<-- adding pgsql if you want use pg_connect in PHP

Andrii Sukhoi · Accepted Answer · 2024-04-16 06:12:18Z

1

For alpine that helps:

RUN apk add --no-cache postgresql-dev && \
docker-php-ext-install pdo pdo_pgsql

answered Apr 16, 2024 at 6:12

Andrii Sukhoi

9017 silver badges15 bronze badges

Collectives™ on Stack Overflow

Installing Postgres driver in php7-fpm Docker container

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related