php - Bd Postgres 连接到 Laravel？

Question

几天前我遇到了一个无法解决的问题，我尝试连接服务器上的 Postgres bd，我使用 laravel 但是当我连接到我的 Postgres bd 时它突出显示了一个错误，这个出现错误

PDOException in Connector.php line 55: SQLSTATE[08006] [7] could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

错误图片:

我想知道是否发生过相同的情况以及如何解决，谢谢!

Answer 1

像这样更改您的 .env 设置:

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1  //If you want to use only in localhost or otherwise change according to host server
DB_PORT=5432
DB_DATABASE=your_database_name
DB_USERNAME=your_username
DB_PASSWORD=your_password

在 .env 修改后，请在终端中输入此命令以清除缓存:php artisan config:cache