Difference between revisions of "Relational and Non-relational Databases"
From Gridkaschool
m (→Overview) |
(→Overview) |
||
Line 1: | Line 1: | ||
= Overview = |
= Overview = |
||
Author: Mario Lassnig, CERN PH-ADP-CO, [mailto:mario.lassnig@cern.ch] |
Author: Mario Lassnig, CERN PH-ADP-CO, [mailto:mario.lassnig@cern.ch] |
||
+ | |||
+ | [[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 |
Revision as of 10:36, 8 September 2015
Overview
Author: Mario Lassnig, CERN PH-ADP-CO, [1]
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