Ubuntu - Tryton server install

Support System Administrator
1

Hello Everyone, I’m new here.

I don’t know to resolve this problem to initialize database.

albert@albert-GL62M-7RDX:~$ trytond-admin -c /etc/tryton/trytond.conf -d tryton_test --all
Traceback (most recent call last):
  File "/home/albert/.local/bin/trytond-admin", line 31, in <module>
    admin.run(options)
  File "/home/albert/.local/lib/python3.10/site-packages/trytond/admin.py", line 35, in run
    database.init()
  File "/home/albert/.local/lib/python3.10/site-packages/trytond/backend/postgresql/database.py", line 358, in init
    cursor.execute(line)
  File "/home/albert/.local/lib/python3.10/site-packages/trytond/backend/postgresql/database.py", line 68, in execute
    cursor.execute(self, sql, args)
psycopg2.errors.InsufficientPrivilege: permission denied for schema public

Thanks

2

It seems that the PostgreSQL user configured does not have right to create table on public schema.

3

Can you tell me how to change these rights, step by step. I don’t have much experience in Ubuntu.

4

You change role with PostgreSQL: Documentation: 15: ALTER ROLE

5

Great!!! Thanks.