How to use PostgreSQL instead of mysql ?

[nicolas-piquerez]

Hello, Have you managed to use postgreSQL ?

I'm trying to replace mysql with postgresql, but I can't get symfony / laravel to connect.

I have the following error when trying to connect to a remote (aws) postgreSQL database : ErrorException in Connection.php line 770: could not find driver

In docker-compose i linked postgre links:

- mail

  #- mysql
  - pgsql

Removed comments from PostgreSQL config #######################################

PostgreSQL server

####################################### pgsql: build: context: docker/postgres/

dockerfile: Postgres-9.4.Dockerfile

  dockerfile: Postgres-9.5.Dockerfile

volumes_from:

- storage

ports:
  - 15432:5432
env_file:
  - etc/environment.yml
  - etc/environment.development.yml

It seems the php7 extension for postgreSQL is missing I tried to install it with "RUN /usr/local/bin/apt-install php7.0-pgsql" but can't find any php packages installed :/

[kyrilg]

Hello, I recently faced the same problem; Here is my Dockerfile.development

FROM webdevops/php-apache-dev:7.1

ENV PROVISION_CONTEXT "development"

COPY etc/ /opt/docker/etc/

RUN ln -sf /opt/docker/etc/cron/crontab /etc/cron.d/docker-boilerplate \

RUN chmod 0644 /opt/docker/etc/cron/crontab \ && echo >> /opt/docker/etc/cron/crontab \ && ln -sf /opt/docker/etc/php/development.ini /opt/docker/etc/php/php.ini

RUN apt-get update

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

RUN apt-get install -y zlib1g-dev libicu-dev g++ \ && docker-php-ext-configure intl \ && docker-php-ext-install intl

Configure volume/workdir

WORKDIR /app/

[mblaschke]

Don't run RUN apt-get update on a single run command, you will create an additional layer which you don't need :)

You can use RUN apt-install libpq-dev ... on our images, this will handle all stuff automatically :)

We've already discussed adding pgsql on our images and will add this too.

[nicolas-piquerez]

Thank you kyrilg. It works like a charm !!

As mblaschke suggested, i tried without the update, but libpq-dev could not be found. So I kept the update for now :)

Can I ask you how is your docker-compose ? I would like to simplify mine by removing the storage container and the docker volume, I don't need the separate app from storage, or at least I can't see the advantages in my case.

version: '2' services: app: build: context: . dockerfile: Dockerfile links:

• postgres ports:
• "8000:80"
• "8443:443"
• "10022:22" volumes:
• ./:/var/app/
• ./:/docker/ volumes_from:
• storage

  cap and privileged needed for slowlog

  cap_add:

• SYS_PTRACE privileged: true env_file:
• etc/environment.yml
• etc/environment.development.yml environment:
• VIRTUAL_HOST=.app.boilerplate.docker
• VIRTUAL_PORT=80

• POSTFIX_RELAYHOST=[mail]:1025

  postgres: build: context: docker/postgres/ dockerfile: Postgres-9.5.Dockerfile ports:

• 15432:5432 env_file:
• etc/environment.yml

• etc/environment.development.yml

  storage: build: context: docker/storage/ volumes:

• /storage

[kyrilg]

@clenoma just replace apt-get install by apt-install and then you can remove apt-get update :) @mblaschke would answer better than me but he already told me that the storage was no longer necessary and should be removed

You can go at https://webdevops.io/slack/ to discuss about that