aboutsummaryrefslogtreecommitdiff
path: root/www/howto_psql
blob: 7d5adfc786f0f2e065158f1fc8646817aa4437a8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
#in order to make things right, you should check the following comments to visualize and use properly the PSQL database.

#assuming that you installed psql prior
#https://www.postgresql.org/download/linux/debian/

#create the user
adduser atsuser
#use the password '123456'

#connect as postgres
su - postgres

#launch the psql terminal
psql

#create the user that we use in our scripts
CREATE USER atsuser WITH PASSWORD '123456';

#create our databse
CREATE DATABASE atsdb;

#grant the privileges to our user
GRANT ALL PRIVILEGES ON DATABASE atsdb to atsuser;

#quit
Ctrl+D

#log in as atsuser
su - atsuser

#launch psql with our user and our database
psql -d atsdb -U atsuser

#initialize the tables
\i /WHATEVER_PATH_YOUR_INIT_IS_IN/ATS-Project/website/init-bd.sql