Laravel 5 + PostgreSQL: "Database [postgres] not configured." Error

Question

I'm trying to get started with Laravel + PostgreSQL and been following the database tutorial.

Unfortunately, after updating the database configuration file and running php artisan migrate, the following error appears:

  [InvalidArgumentException]
  Database [postgres] not configured.

What puzzles me is that I didn't specify the "postgres" database in the configuration, but another database I set through cPanel, say "example_database".

Here's some relevant parts of my /config/database.php configuration:

'default' => env('DB_CONNECTION', 'postgres')

And inside the connections array of the same file:

'pgsql' => [
        'driver'   => 'pgsql',
        'host'     => env('DB_HOST', 'localhost'),
        'database' => env('DB_DATABASE', 'example_database'), // This seems to be ignored
        'username' => env('DB_USERNAME', 'example_username'),
        'password' => env('DB_PASSWORD', 'example_password'),
        'charset'  => 'utf8',
        'prefix'   => '',
        'schema'   => 'public'
    ],

The actual database credentials I'm using are working perfectly on my SQL Workbench client, so this seems to be a Laravel config problem. Any ideas? I have searched around for at least an hour to no avail.

Jerry U · Accepted Answer · 2018-05-18 05:47:42Z

63

You have to enter your configuration in the .env file.

The configuration you made will only be loaded if they are not already defined in .env

You need to use pgsql instead of postgres.

DB_CONNECTION=pgsql
DB_HOST=localhost
DB_DATABASE=DB_NAME
DB_USERNAME=USER
DB_PASSWORD=PW

edited May 18, 2018 at 5:47

Jerry U

63610 silver badges22 bronze badges

answered Jan 31, 2016 at 8:33

Fiete

1,34211 silver badges13 bronze badges

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

7 Comments

hodgef Over a year ago

Thanks for the explanation. I've made the change in the .env file but the error is the same. Is there something else I'm missing?

Fiete Over a year ago

@FranciscoH. I just updated my answer. rename postgress to pgsql.

Fiete Over a year ago

Did you also have checked if the pdo postgress driver is installed and loaded correctly?

Brian Peterson Over a year ago

"You need to use pgsql instead of postgres." This was hard to find information! Thanks.

Kelvin Omereshone Over a year ago

This answer works for me perfectly. I am using ssh with homestead on a Linux machine.

|

Bubunyo Nyavor · Accepted Answer · 2019-04-23 11:45:37Z

8

Laravel sometimes caches your configurations. If you run into this problem while everything looks alright try running

php artisan config:cache

answered Apr 23, 2019 at 11:45

Bubunyo Nyavor

2,5701 gold badge26 silver badges37 bronze badges

Comments

Cristea · Accepted Answer · 2022-03-11 14:53:21Z

3

I know this is an old question and it already has an answer; however, here is an small explanation why:

If you check your database.php in the config directory, you will see that you have few connections types, including pgsql. So, the key have to match to the DB_CONNECTION in .env file. You can definitely replace pqsql connection key with postgres, and it will work on the same way.

However, I would recommend replacing the value DB_CONNECTION, instead of modifying the config.

DB_CONNECTION=pgsql

answered Mar 11, 2022 at 14:53

Cristea

1,08513 silver badges19 bronze badges

Collectives™ on Stack Overflow

Laravel 5 + PostgreSQL: "Database [postgres] not configured." Error

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related