title: Lumen - Postgresql setup - Composer
body: <p>really strugling on this one, it's not the first I try to set this up but I really can't see why it's not working.</p>
  
  <p>So this is my app.docker file:</p>
  
  <pre><code>FROM php:7-fpm
  # Install modules
  RUN buildDeps="libpq-dev libzip-dev libfreetype6-dev libjpeg62-turbo-dev libpng-dev " &amp;&amp; apt-get update &amp;&amp; apt-get install -y $buildDeps --no-install-recommends &amp;&amp; rm -rf /var/lib/apt/lists/* \
      &amp;&amp; docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
      &amp;&amp; docker-php-ext-install pdo pdo_pgsql pgsql gd
  
  WORKDIR /var/www
  
  COPY . /var/www
  
  RUN chown www-data:www-data -R ./storage
  
  RUN ln -s /storage/app/public /public
  </code></pre>
  
  <p>Pretty simple. Next comes the output of phpinfo()</p>
  
  <p><a href="https://i.stack.imgur.com/w1vS5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w1vS5.png" alt="enter image description here"></a></p>
  
  <p>I understand that the pgsql driver is now installed, however, when running php artisan migrate I still get </p>
  
  <p><a href="https://i.stack.imgur.com/Dzxo1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dzxo1.png" alt="enter image description here"></a></p>
  
  <p>This is my config/database.php file.</p>
  
  <pre><code>return [
      'default' =&gt; 'postgres',
      'migrations' =&gt; 'migrations',
      'connections' =&gt; [
          'mysql' =&gt; [
              'driver'    =&gt; 'mysql',
              'host'      =&gt; env('DB_HOST'),
              'database'  =&gt; env('DB_DATABASE'),
              'port'      =&gt; env('DB_PORT'),
              'username'  =&gt; env('DB_USERNAME'),
              'password'  =&gt; env('DB_PASSWORD'),
              'charset'   =&gt; 'utf8',
              'collation' =&gt; 'utf8_unicode_ci',
              'prefix'    =&gt; '',
              'strict'    =&gt; false,
          ],
          'mysql_postal_code' =&gt; [
              'driver'    =&gt; 'mysql',
              'host'      =&gt; env('DB_HOST', 'localhost'),
              'database'  =&gt; env('DB_DATABASE_POSTAL_CODE'),
              'port'      =&gt; env('DB_PORT'),
              'username'  =&gt; env('DB_USERNAME'),
              'password'  =&gt; env('DB_PASSWORD'),
              'charset'   =&gt; 'utf8',
              'collation' =&gt; 'utf8_unicode_ci',
              'prefix'    =&gt; '',
              'strict'    =&gt; false,
          ],
          'postgres' =&gt; [
              'driver'   =&gt; 'pgsql',
              'host'     =&gt; env('DB_PG_HOST', 'database_p'),
              'database' =&gt; env('DB_PG_DATABASE', 'dockerApp'), // This seems to be ignored
              'port'     =&gt; env('DB_PG_PGSQL_PORT', 5432),
              'username' =&gt; env('DB_PG_USERNAME', 'postgres'),
              'password' =&gt; env('DB_PG_PASSWORD', 'secret'),
              'charset'  =&gt; 'utf8',
              'prefix'   =&gt; '',
              'schema'   =&gt; 'public'
          ]
      ],
      'redis' =&gt; [
          'cluster' =&gt; false,
          'default' =&gt; [
              'host' =&gt; env('REDIS_HOST', 'localhost'),
              'password' =&gt; env('REDIS_PASSWORD', null),
              'port' =&gt; env('REDIS_PORT', 6379),
              'database' =&gt; 0,
          ],
      ],
  ];
  </code></pre>
  
  <p>What can I be missing?</p>