document database creation step in postgres in README.md

[micahstubbs]

this projects looks fantastic. I'm stuck at this point of the dev setup described in the README.md:

npm run up

after which I see:

[ERROR] error: role "teamchatviz" does not exist

I'm sure that this step is obvious if you work with postgres all the time. that said, it would be super helpful. to document the things you need to do before you can run npm run up successfully 😄

[OrKoN]

Hi @micahstubbs,

in order to create a DB in Postgres you need to start psql. On Linux systems you can run sudo -u postgres psql. On OS X you can start it via the UI of Postgres.app.

Once you are in, you can run the following commands to create a user called teamchatviz with the password teamchatviz and a database called teamchatviz:

CREATE DATABASE teamchatviz;
CREATE ROLE teamchatviz WITH LOGIN CREATEDB PASSWORD 'teamchatviz';
ALTER USER teamchatviz VALID UNTIL 'infinity';
ALTER DATABASE teamchatviz OWNER TO teamchatviz;
GRANT ALL ON DATABASE teamchatviz TO teamchatviz;
\c teamchatviz
ALTER SCHEMA public OWNER TO teamchatviz;

Please let me know if this worked for you and I will add it to the README.

[micahstubbs]

starting psql from the postgres mac gui

[micahstubbs]

I think the migration succeeded

[micahstubbs]

it works! now have teamchatviz up and running locally 🎉 🙏 @OrKoN 👍 for adding the text to the README.md 😄

here's the emoji timeline for one of my teams:

[OrKoN]

thanks @micahstubbs I have added the steps to the README. I am happy that you like the project! Please let me know if you have further questions about the setup or if you have any ideas about improving the project or adding new features!