Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

docs: document creation of __reana schema #59

Open
diegodelemos opened this issue Sep 17, 2020 · 0 comments
Open

docs: document creation of __reana schema #59

diegodelemos opened this issue Sep 17, 2020 · 0 comments

Comments

@diegodelemos
Copy link
Member

When deploying REANA on an external DB system admins might not have permissions to create the __reana schema

Possible solutions to be documented

    1. Grant schema creation privilege
$ pgcli -h reana.external.db -p 6666 -U admin reana
reanaqa> GRANT CREATE ON DATABASE reana TO reana;
    1. Create schema manually with admin user
$ pgcli -h reana.external.db -p 6666 -U admin reana
reanaqa> CREATE SCHEMA __reana
reanaqa> GRANT ALL ON SCHEMA __reana TO postgres;
reanaqa> GRANT ALL ON SCHEMA __reana TO public;

Stems from reanahub/reana-db#81.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant