Create new site with db-type postgres


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 :sweat_smile:

you can track here New-site fails on PostgreSQL v15 · Issue #18489 · frappe/frappe · GitHub

1 Like

Thank you very much for your help :slight_smile: perfectly the problem is my Postgres v15 not compatible . I modify to less version and it work.