From 8850bb41eb9ef803e33a876e9017f378fc74637b Mon Sep 17 00:00:00 2001 From: cly Date: Sun, 22 Mar 2020 13:15:09 +0100 Subject: renamed and modified --- web/help.txt | 35 ----------------------------------- web/howto_psql | 35 +++++++++++++++++++++++++++++++++++ 2 files changed, 35 insertions(+), 35 deletions(-) delete mode 100644 web/help.txt create mode 100644 web/howto_psql diff --git a/web/help.txt b/web/help.txt deleted file mode 100644 index fc3d38e..0000000 --- a/web/help.txt +++ /dev/null @@ -1,35 +0,0 @@ -#in order to make thing 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 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