Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

ludo1960's avatar

PHP 7.3 Laravel can't connect to pgsql

Hi folks,

I upgraded my php vesion to 7.3 today and installed a new laravel 5.8 test site. When I run php artisan make:auth seems the laravel package can't communicate with the postgres database. I get the error

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "users" does not exist LINE 1: select count(*) as aggregate from "users" where "email" =  ^ (SQL: select count(*) as aggregate from "users" where "email" = [email protected])  

I changed the .env file to pgsql and port to 5432 as well as changing config/databases.php defailt to pgsql and changed 'schema' => env('DB_PGSQL_SCHEMA','public'),

I had laravel pgsql and nginx all working nicely together. Until the php 7.3 update that is. Anyone else having the issue?

Forgot to add I can access the database:

 $myPDO = new PDO('pgsql:host=localhost;dbname=slim2', 'user', 'password');



if (!defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO unavailable';
}
this works too.
0 likes
1 reply
ludo1960's avatar

Seems when php7.3 was upgraded it didn't upgrade all the extensions, had to update mbstring an dom, all working now!

Please or to participate in this conversation.