Ok, So How do I run queue:work but for multi tenancy where I am using Postgres Multi Schema?

[ax-prashant]

jobs table and failed_jobs table are also on schema level

[marius-ciclistu]

You mean with database driver?

[macropay-solutions]

Database driver for queues should be avoided in prod.

Considering that you have the jobs table and the failed_jobs table in each schema of your database:

php artisan queue:work tenant1connection --name=tenant1

//When pushing to a queue you must set also the connection.

Job::dispatch(...)->onConnection('tenant1conection');

And also you need to configure as many connections as tenants.

Maybe there is another way of doing this so you avoid the per tenant worker and connection.

[ax-prashant]

So what do you suggest?

[macropay-solutions]

You should try and see if it works.

[ax-prashant]

I used redis. Awesome it is