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鈥檙e using Postgres v15. Frappe isn鈥檛 compatible with it yet. We need to grant permission to public schema by default to make it work. I鈥檇 written a fix but haven鈥檛 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.