Hello,
I'm facing an issue while trying to run Laravel migrations on a PostgreSQL database.
Whenever I execute php artisan migrate
I receive the following error:
`Creating migration table ................................................................................................................ 7ms FAIL
Illuminate\Database\QueryException
SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema public at character 14 (Connection: pgsql, SQL: create table "migrations" ("id" serial not null primary key, "migration" varchar(255) not null, "batch" integer not null))
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:801
797▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
798▕ );
799▕ }
800▕
➜ 801▕ throw new QueryException(
802▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
803▕ );
804▕ }
805▕ }
+39 vendor frames
40 artisan:38
Illuminate\Foundation\Console\Kernel::handle()
root@vmi1766336:/www/wwwroot/lite.coinspay.xyz# `
PgSQL Version: 16.1