From a6e0225c9e22d76fae9493008cad8510d94905e9 Mon Sep 17 00:00:00 2001 From: clyhtsuriva Date: Sun, 29 Mar 2020 19:56:43 +0200 Subject: web deleted --- web/howto_psql | 35 ----------------------------------- 1 file changed, 35 deletions(-) delete mode 100755 web/howto_psql (limited to 'web/howto_psql') diff --git a/web/howto_psql b/web/howto_psql deleted file mode 100755 index 7d5adfc..0000000 --- a/web/howto_psql +++ /dev/null @@ -1,35 +0,0 @@ -#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 -- cgit v1.2.3