How to define schema migration Laravel Postgres?

Question

Im using a multitenant package in Laravel called Laravel Tenancy and i change the setting to work with SCHEMA, every tenant has your schema right?

Well i'm using postgres and I'd like to change 'public' the default schema, i'd like to use maindatabase.

I have changed it in:

'connections' => [
        'pgsql' => [
            'driver' => 'pgsql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'schema' => 'maindatabase',
            'sslmode' => 'prefer',
        ],
]

But when I execute php artisan migrate i have this error:

Illuminate\Database\QueryException : SQLSTATE[3F000]: Invalid schema name: 7 ERROR: no schema has been selected to create in at character 14 (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))

How can I fix it? Thank you

see here enter link description here

ZAKARIA ABOUD
– ZAKARIA ABOUD

2019-07-25 16:15:23 +00:00
Commented Jul 25, 2019 at 16:15 — ZAKARIA ABOUD
– ZAKARIA ABOUD, Commented Jul 25, 2019 at 16:15
There's no solution in this reference :(

Hermus
– Hermus

2019-07-25 16:25:24 +00:00
Commented Jul 25, 2019 at 16:25 — Hermus
– Hermus, Commented Jul 25, 2019 at 16:25
do maindatabase schema already exist?

dparoli
– dparoli

2019-07-25 19:32:42 +00:00
Commented Jul 25, 2019 at 19:32 — dparoli
– dparoli, Commented Jul 25, 2019 at 19:32
Yep..it exist @dparoli

Hermus
– Hermus

2019-07-25 21:24:18 +00:00
Commented Jul 25, 2019 at 21:24 — Hermus
– Hermus, Commented Jul 25, 2019 at 21:24
Make sure you have all USAGE privilege to that schema.

dparoli
– dparoli

2019-07-25 21:57:06 +00:00
Commented Jul 25, 2019 at 21:57 — dparoli
– dparoli, Commented Jul 25, 2019 at 21:57

dparoli · Accepted Answer · 2019-07-26 06:53:11Z

2

Make sure you have all USAGE privilege to that schema, i.e.:

GRANT USAGE ON SCHEMA maindatabase TO your_username;

answered Jul 26, 2019 at 6:53

dparoli

9,1911 gold badge34 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

How to define schema migration Laravel Postgres?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related