I want to modify my current site from using mariadb to use postgres
I try to create new site with db-type postgres , I do :
bench new-site sitename --db-type postgres
but it return error :
ERROR: permission denied for schema public
LINE 1: CREATE TABLE "tabDocField" ().
any help please
It looks like you’re using Postgres v15. Frappe isn’t compatible with it yet. We need to grant permission to public schema by default to make it work. I’d written a fix but haven’t quite got time to finish it
you can track here New-site fails on PostgreSQL v15 · Issue #18489 · frappe/frappe · GitHub
Thank you very much for your help perfectly the problem is my Postgres v15 not compatible . I modify to less version and it work.