Docker PHP Image with PostgreSQL Driver

php5.6-pgsql.Dockerfile

FROM php:5.6-apache

RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql

COPY src/ /var/www/html

Thank you! 😀

thx :)

Thanks for sharing.
In my case it was necessary to add the pgsql extension:
docker-php-ext-install pgsql pdo pdo_pgsql

👍

FROM php:7.2.6-apache

RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql

perfectly worked on php:7.1-apache.
thanks

Thanks 👍

@ricardson @obadaro @ben-albon Thanks

thanks, works very well..

Thank you.
Completing how to install which you wrote, I succeeded to install pdo_pgsql.

Thanks a lot!

Thanks for the snipped. You are great!!!

Brilliant, this has changed everything about the way we work.

I've spent the last nine years searching for this solution. It's the best three lines of config I have ever seen. Thank you.

Thanks mate.

PHP 4.4 :(

Thanks a lot !!

FROM php:7.4.2-apache-buster
RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql``

My Dockerfile uses "FROM bitnami/php-fpm:7.2" rather than the Apache container. So I will use

FROM bitnami/php-fpm:7.2
RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql

Is this doomed to failure?

My Dockerfile uses "FROM bitnami/php-fpm:7.2" rather than the Apache container. So I will use

FROM bitnami/php-fpm:7.2
RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql

Is this doomed to failure?

This could work but you'd have to ensure that your apache handles requests to php though PHP-FPM

thank brow! 👍

Thanks 🚀

so good!

Thanks 👍

Dude, thanks very much!

Works also on PHP 8.0 👍

Works also on PHP 8.1, thanks

very much!!

php:8-apache

3.563 E: Unable to locate package docker-php-ext-install
3.563 E: Unable to locate package pgsql
3.563 E: Unable to locate package pdo
3.563 E: Unable to locate package pdo_pgsql

big thanks!

my dockerfile:

FROM php:8.3.20-bullseye 

RUN apt-get update && apt-get install -y libpq-dev && docker-php-ext-install pdo pdo_pgsql

COPY . /app
WORKDIR /app

CMD [ "php", "-S", "0.0.0.0:20000", "-t", "public" ]