Add instructions on how to add roles in psql and that you need to create a role "courtbot" to Readme

codeforanchorage / courtbot

Your friendly neighborhood court robot. Provides an api for getting court case information.

https://courtbot.codeforanchorage.org

ISC License

7 stars 10 forks source link

Add instructions on how to add roles in psql and that you need to create a role "courtbot" to Readme #39

Closed simonv3 closed 6 years ago

simonv3 commented 7 years ago

A good walkthrough from Digital Ocean.

For example:

with psql running:

$ psql
CREATE ROLE courtbot;
ALTER ROLE courtbot with LOGIN;
CREATE DATABASE courtbotdb;
GRANT ALL PRIVILEGES ON DATABASE courtbotdb TO courtbot;
\q

Thoughts? I can gladly add these, but there might already be a script that does these things?

mark-meyer commented 6 years ago

The current README now has instructions using the Postgres command line utilities createuser and createdb. I think that should work for just about everyone, but if I'm wrong about that please reopen this and we can add more details.