Elcaro tutorial tip: Postgtresql new user & db creation

elcaro_postgresql_create_user

$ sudo apt-get install postgresql
$ sudo -i -u postgres
$ psql

CREATE USER elcaro;
ALTER ROLE elcaro WITH CREATEDB;
CREATE DATABASE "ElCaro" OWNER elcaro;
ALTER USER elcaro WITH ENCRYPTED PASSWORD 'elcaro';
\q

$ postgres@computer:~$ exit
$ cd /path/to/elcaro
$ psql -U elcaro -d ElCaro -f sql/structure.sql