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

Add instructions to quick-start to set up database permissions #47

Open
mcapodici opened this issue Sep 15, 2023 · 0 comments
Open

Add instructions to quick-start to set up database permissions #47

mcapodici opened this issue Sep 15, 2023 · 0 comments

Comments

@mcapodici
Copy link
Contributor

Describe the bug
The steps on https://docs.nextacular.co/getting-started/quick-start are not completely clear.

To Reproduce
Steps to reproduce the behavior:

  1. Look at the steps above
  2. There is no indication of how to set up your developer DB
  3. If you forget to ALTER USER nextacular CREATEDB; it seems to come up with error:

Error: P3014

Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow

Expected behavior
Instructions on how to create the Postgres DB. E.g.

CREATE USER nextacular WITH PASSWORD 'nextacular';
CREATE DATABASE nextaculardb WITH OWNER = 'nextacular';
GRANT ALL PRIVILEGES ON DATABASE nextaculardb TO nextacular;
ALTER USER nextacular CREATEDB;

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: Windows 11
  • Browser: N/A
  • Version: N/A
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