Can't install pdo_psql with docker-php-ext-install #221

zot24 · 2016-04-13T16:52:21Z

I was trying to install pdo_psql on fpm-alpine flavour like:

docker-php-ext-install pdo pdo_pgsql

I was getting first the following error:

configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path

So I decide to install libpq:

RUN echo "@edge http://nl.alpinelinux.org/alpine/edge/main" >> /etc/apk/repositories
RUN apk --no-cache add \
    libpq@edge

Same error after that and then I try installing postgresql like:

RUN echo "@edge http://nl.alpinelinux.org/alpine/edge/main" >> /etc/apk/repositories
RUN apk --no-cache add \
    postgresql \
    libpq@edge

And then getting different error:

configure: error: Unable to build the PDO PostgreSQL driver: a newer libpq is required

That's why I'm trying with the edge version of libpq but...

And I'm get stuck in this step not sure what could be wrong but I can't install pdo_pgsql

btw my infrastructure it's have one container per thing, so I have a container for nginx and a container for php-fpm and another container with postgres so my goal it's have everything split between containers

The text was updated successfully, but these errors were encountered:

zot24 · 2016-04-14T08:15:53Z

Could this issue be related with the C libraries on Alpine? I have notice you are using g++ and gcc

zot24 · 2016-04-14T12:45:02Z

Ok! fix my issue! :)

It's kind of related with this https://bugs.alpinelinux.org/issues/3642 and this https://bugs.alpinelinux.org/issues/4109

And what I did to fix it was install first postgresql-dev like so:

FROM php:fpm-alpine

RUN set -ex \
  && apk --no-cache add \
    postgresql-dev

RUN docker-php-ext-install pdo pdo_pgsql

And that works! :) the links suggest that we should have a small package to satisfy that dependency and be able to install the pdo_psql

Aliance · 2016-10-17T09:10:41Z

The same issue but on php:5.6-fpm, not alpine.

FROM php:5.6-fpm

RUN docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \
    && docker-php-ext-install pgsql pdo_pgsql

configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path

The solution as above is:

FROM php:5.6-fpm

RUN apt-get update

# Install Postgre PDO
RUN apt-get install -y libpq-dev \
    && docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \
    && docker-php-ext-install pdo pdo_pgsql pgsql

isuftin · 2017-05-03T13:43:48Z

@Aliance This also fixes the issue for php:apache 👍

set -ex \ && apk --no-cache add \ postgresql-dev docker-library/php#221

https://hub.docker.com/_/php/ docker-library/php#221 https://stackoverflow.com/a/39501539 docker-compose -f docker-compose.yml up --build -d queue_daemon docker logs basecamp-costlocker-queue -f

…rary/php#221 (comment).

robov · 2017-12-04T19:02:41Z

I am facing the same issue, but when I follow zot24 advice... the pdo is installed and seems to work BUT
when I then run psql in the shell I get

Error relocating /usr/bin/psql: PQresultVerboseErrorMessage: symbol not found
Error relocating /usr/bin/psql: PQsetErrorContextVisibility: symbol not found
Error relocating /usr/bin/psql: PQencryptPasswordConn: symbol not found

Any suggestions

robov · 2017-12-04T19:14:31Z

Basically when I add postgresql-dev to my current installation pf postgresql (10.1) then I no longer can use psql command... drives me nuts

robov · 2017-12-04T19:57:30Z

I now solved it like this:

#... install postgres pdo
set -ex \
  && apk --no-cache add \
    postgresql-dev

docker-php-ext-install pdo pdo_pgsql
apk del postgresql-dev
apk add --upgrade postgresql --update-cache --repository http://dl-3.alpinelinux.org/alpine/edge/main/

inta · 2018-05-01T20:09:14Z

I got stuck on the same problem and your comments did help me to get it running, but you do not need to install the complete postgres package, postgres-libs is sufficient (pdo is already installed, but I needed to install the pgsql extension):

RUN set -ex \
	&& apk --no-cache add postgresql-libs postgresql-dev \
	&& docker-php-ext-install pgsql pdo_pgsql \
	&& apk del postgresql-dev

acodercat · 2018-09-11T01:59:53Z

apt-get install libpq-dev

stevleibelt · 2018-09-19T11:49:45Z

Thanks @acodercat ,
your solution is still "doing the trick" if you are using the docker container "php:7.1-cli".

apt-get install libpq-dev
&& docker-php-ext-install pdo_pgsql

tianon · 2018-11-06T13:57:30Z

You probably need to run "apt-get update" first. 😉

PedroDiSanti · 2018-11-08T17:49:41Z

The same issue but on php:5.6-fpm, not alpine.
FROM php:5.6-fpm

RUN docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \
    && docker-php-ext-install pgsql pdo_pgsql
configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path

The solution as above is:
FROM php:5.6-fpm

RUN apt-get update

# Install Postgre PDO
RUN apt-get install -y libpq-dev \
    && docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \
    && docker-php-ext-install pdo pdo_pgsql pgsql

Thank you so much, mate.

Without lines 6-8, I get an error `configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path` Applied fix suggested in docker-library/php#221 (comment) Re: `--no-cache option` in `apk` command, see https://stackoverflow.com/questions/49118579/ alpine-dockerfile-advantages-of-no-cache-vs-rm-var-cache-apk

luispabon · 2020-03-19T11:32:09Z

If somebody stumbles upon this and you're using one of the debian based images:

FROM php:apache

RUN apt-get update; \
    apt-get install -y libpq5 libpq-dev; \
    docker-php-ext-install pdo pdo_pgsql; \
    apt-get autoremove --purge -y libpq-dev; \
    apt-get clean ; \
    rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/* /usr/share/doc/*

Note: you must leave libpq5 for the psql extension to function. Its dev headers though are only needed for compiling the php extension and can and should be removed.

hung5s · 2020-04-04T23:57:20Z

My addition of pdo_pgsql for urbit/lumen-php-fpm:

FROM urbit/lumen-php-fpm

RUN apk --no-cache --update --repository http://dl-
cdn.alpinelinux.org/alpine/v$ALPINE_VERSION/main/ add \
    postgresql-dev

RUN docker-php-ext-install pdo_pgsql

This reduces the image size in my tests from 426 MB to 110 MB the steps are taken from docker-library/php#221 (comment)

oyepez003 · 2021-07-15T23:22:51Z

RUN apt-get install -y libpq-dev \
    && docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql \
    && docker-php-ext-install pdo pdo_pgsql pgsql

zot24 closed this as completed Apr 14, 2016

9034725985 added a commit to openroom/phpci that referenced this issue Aug 18, 2017

add set command

b8c6acb

set -ex \ && apk --no-cache add \ postgresql-dev docker-library/php#221

furkle pushed a commit to furkle/twinepm-server-heroku that referenced this issue Sep 16, 2017

Another attempt at fixing pdo_pgsql install issue based on docker-lib…

f8a891f

…rary/php#221 (comment).

NickToony mentioned this issue Oct 28, 2017

Fix: Missing PGSQL drivers on PHP-Workers laradock/laradock#1217

Closed

peterjaap mentioned this issue Aug 31, 2020

Add Postgresql JeroenBoersma/docker-compose-development#131

Closed

StefanSchoof added a commit to StefanSchoof/volkszaehler.org that referenced this issue Jul 13, 2021

Remove postgresql-dev after building the driver

7a9f9b1

This reduces the image size in my tests from 426 MB to 110 MB the steps are taken from docker-library/php#221 (comment)

StefanSchoof added a commit to StefanSchoof/volkszaehler.org that referenced this issue Jul 14, 2021

Remove postgresql-dev after building the driver

01e1224

This reduces the image size in my tests from 426 MB to 110 MB the steps are taken from docker-library/php#221 (comment)

StefanSchoof mentioned this issue Jul 14, 2021

[Docker] Remove postgresql-dev after building the driver volkszaehler/volkszaehler.org#865

Merged

andig pushed a commit to volkszaehler/volkszaehler.org that referenced this issue Jul 14, 2021

Remove postgresql-dev after building the driver (#865)

b2e4cd9

This reduces the image size in my tests from 426 MB to 110 MB the steps are taken from docker-library/php#221 (comment)

docker-library locked as resolved and limited conversation to collaborators Jul 16, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Can't install pdo_psql with docker-php-ext-install #221

Can't install pdo_psql with docker-php-ext-install #221

zot24 commented Apr 13, 2016

zot24 commented Apr 14, 2016

zot24 commented Apr 14, 2016

Aliance commented Oct 17, 2016 •

edited

Loading

isuftin commented May 3, 2017

robov commented Dec 4, 2017

robov commented Dec 4, 2017

robov commented Dec 4, 2017

inta commented May 1, 2018

acodercat commented Sep 11, 2018

stevleibelt commented Sep 19, 2018

tianon commented Nov 6, 2018 via email

PedroDiSanti commented Nov 8, 2018

luispabon commented Mar 19, 2020 •

edited

Loading

hung5s commented Apr 4, 2020 •

edited

Loading

oyepez003 commented Jul 15, 2021

Can't install pdo_psql with docker-php-ext-install #221

Can't install pdo_psql with docker-php-ext-install #221

Comments

zot24 commented Apr 13, 2016

zot24 commented Apr 14, 2016

zot24 commented Apr 14, 2016

Aliance commented Oct 17, 2016 • edited Loading

isuftin commented May 3, 2017

robov commented Dec 4, 2017

robov commented Dec 4, 2017

robov commented Dec 4, 2017

inta commented May 1, 2018

acodercat commented Sep 11, 2018

stevleibelt commented Sep 19, 2018

tianon commented Nov 6, 2018 via email

PedroDiSanti commented Nov 8, 2018

luispabon commented Mar 19, 2020 • edited Loading

hung5s commented Apr 4, 2020 • edited Loading

oyepez003 commented Jul 15, 2021

Aliance commented Oct 17, 2016 •

edited

Loading

luispabon commented Mar 19, 2020 •

edited

Loading

hung5s commented Apr 4, 2020 •

edited

Loading