From 8850bb41eb9ef803e33a876e9017f378fc74637b Mon Sep 17 00:00:00 2001
From: cly <clyhtsuriva@gmail.com>
Date: Sun, 22 Mar 2020 13:15:09 +0100
Subject: renamed and modified

---
 web/howto_psql | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 web/howto_psql

(limited to 'web/howto_psql')

diff --git a/web/howto_psql b/web/howto_psql
new file mode 100644
index 0000000..4da0d3e
--- /dev/null
+++ b/web/howto_psql
@@ -0,0 +1,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
-- 
cgit v1.2.3