- Start postgres (example):
su postgres
service postgresql start

- Create database
create database rin544_dev

- Create the user to be used by the app to access the database:
\c rin544_dev
CREATE USER myUser WITH ENCRYPTED PASSWORD 'myUser';
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myUser;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO myUser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to myUser;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to myUser;
\q
exit

- Update the app's database configuration
vim config/config.json
- set user/pass to :
myUser/myUser