Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save chanmix51/5795635 to your computer and use it in GitHub Desktop.
Save chanmix51/5795635 to your computer and use it in GitHub Desktop.
$ sudo apt-get install postgresql
$ sudo -i -u postgres
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment