Relational and Non-relational Databases

From Gridkaschool
Revision as of 10:36, 8 September 2015 by Mlassnig (talk | contribs) (→‎Overview)
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Overview

Author: Mario Lassnig, CERN PH-ADP-CO, [1]

File:Slides.pdf

PostgreSQL

vim /var/lib/pgsql/9.4/data/pg_hba.conf

set all to trust

add line 

host all all 0.0.0.0/0 trust

psql -U gridka01 gridka_db

should not ask for password ctrl-d to exit 

sudo -u postgres /usr/pgsql-9.4/bin/psql -c "CREATE ROLE gridka01 PASSWORD 'asdf1234' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;"
sudo -u postgres /usr/pgsql-9.4/bin/psql -c "CREATE DATABASE gridka_db OWNER gridka01 ENCODING 'UTF8'"
sudo -u postgres /usr/pgsql-9.4/bin/psql -d gridka_db -c "CREATE SCHEMA gridka_schema AUTHORIZATION gridka01"
sudo -u postgres /usr/pgsql-9.4/bin/psql -d gridka_db -c "GRANT ALL ON SCHEMA gridka_schema TO gridka01"
sudo -u postgres /usr/pgsql-9.4/bin/psql -d gridka_db -c "GRANT ALL ON DATABASE gridka_db TO gridka01"

vim /var/lib/pgsql/9.4/data/pg_hba.conf

set all to md5 

systemctl restart postgresql-9.4.service

psql -U gridka01 gridka_db

should ask for password 

ldconfig
Retrieved from "https://wiki.scc.kit.edu/gridkaschool/index.php?title=Relational_and_Non-relational_Databases&oldid=2071"