Create new site with db-type postgres

ERPNext
, , , ,
1

Hello,

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

2

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
3

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.