search

grandma-collaboration / skyportal_grandma_dev

Little Git Repo to keep track of the work done by the A4 ESILV TEAM
2 stars 0 forks source link

permission denied for schema public in 'make log' #32

Closed Adiman007 closed 1 year ago

Adiman007 commented 1 year ago

This is an issue about an error we met with @Theodlz during my installation of Skyportal,

Creating tables on database skyportal Could not connect to database...sleeping 3 (psycopg2.errors.InsufficientPrivilege) permission denied for schema public

solution :

In the terminal :

sudo -u postgres psql postgres

inside of the postgres shell :

\c skyportal
GRANT USAGE,CREATE ON SCHEMA public TO postgres; 
GRANT USAGE,CREATE ON SCHEMA public TO skyportal;