document database creation step in postgres in README.md about teamchatviz HOT 5 CLOSED

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:

from teamchatviz.

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!

from teamchatviz.

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.

from teamchatviz.

starting psql from the postgres mac gui

from teamchatviz.

I think the migration succeeded

from teamchatviz.