blob: 4da0d3e6c97b0b7bc0e8050d5202761d9a4167f1 (
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/init-bd.sql
|
