Laravel Database [postgres] not configured

Question

Can anyone help me to fix this problem please the error is database [postgres] not configured.

here is my .env file :

   DB_CONNECTION=postgres
   DB_HOST=localhost
   DB_PORT=5432
   DB_DATABASE=referentiel
   DB_USERNAME=postgres
   DB_PASSWORD=postgres

and here is my database.php:

  'default' => 'postgres',

    'pgsql' => [
        'driver' => 'pgsql',
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '5432'),
        'database' => 'referentiel',
        'username' => env('postgres', ''),
        'password' => env('postgres', ''),
        'charset' => 'utf8',
        'prefix' => '',
        'schema' => 'public',
        'sslmode' => 'prefer',
    ],

DevK · Accepted Answer · 2018-04-23 20:01:06Z

3

Change the default parameter in your config to match the name of your postgres connection - pgsql in your case:

'default' => 'pgsql',

And put correct database parameters in your .env file.

answered Apr 23, 2018 at 20:01

DevK

10k2 gold badges33 silver badges51 bronze badges

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

3 Comments

Lyes Over a year ago

it's settled but i got an other error "could not find driver" do you have any idea ?

patricksweeney Over a year ago

Does your server actually have the postgres extension enabled in your php.ini?

DevK Over a year ago

Like patricksweeney said, you probably need to install the drivers for your PHP version this should get you on the right track, but I've never used it myself and can't help you with that part.

Dorin Musteața · Accepted Answer · 2018-04-23 20:01:41Z

2

Try to edit your .env

From: DB_CONNECTION=postgres

To: DB_CONNECTION=pgsql

answered Apr 23, 2018 at 20:01

Dorin Musteața

1601 silver badge12 bronze badges

3 Comments

Dorin Musteața Over a year ago

try to change 'default' => 'pgsql` as @devk mentioned

Dorin Musteața Over a year ago

if that's not working try to exec command : php artisan config:cache

Fusion Over a year ago

This commend is profoundly useful in case you are dealing with multi-containered application.

Me Loon · Accepted Answer · 2018-04-24 05:51:58Z

0

i think the problem in php.ini if you use xampp open app xampp > config > php.ini

find ;extension=php_pdo_pgsql.dll ;extension=php_pdo_sqlite.dll

delete ;

change extension=php_pdo_pgsql.dll extension=php_pdo_sqlite.dll

answered Apr 24, 2018 at 5:51

Me Loon

243 bronze badges

Collectives™ on Stack Overflow

Laravel Database [postgres] not configured

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related