data_management_framework/setup_database.sh at main · darrahts/data_management_framework · GitHub

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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
#!/bin/bash

################################################################################
################################################################################
#
#        This script will promt the user to
#            1. install PostgreSQL
#            2. install timescale db
#            3. setup the database and user
#            4. setup the table schema
#            5. enable timescaledb extension
#
#
#
#        Tim Darrah
#        NASA Fellow
#        PhD Student
#        Vanderbilt University
#        timothy.s.darrah@vanderbilt.edu
#
################################################################################
################################################################################


###  install PostgreSQL  ###
############################
read -p "install postgreSQL? (y/n): " ans
if [[ $ans = y ]]
then
    # Create the file repository configuration:
    sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

    # # Import the repository signing key:
    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

    # # Update the package lists:
    sudo apt-get update

    # # Install the latest version of PostgreSQL.
    # # If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql':
    sudo apt-get -y install postgresql postgresql-contrib
fi
unset ans


###  install timescale  ###
###########################
read -p "install timescaledb? (y/n): " ans
if [[ $ans = y ]]
then
    ./install_timescale.sh
fi
unset ans


###  create the database and user  ###
######################################
read -p "setup database? (y/n): " ans
if [[ $ans = y ]]
then
    read -p "enter your password: " PASSWORD
    read -p "enter the database name: " DB_NAME
    sudo -u postgres psql -f sql/create_user_database.sql -v user="$USER" -v passwd="'$PASSWORD'" -v db_name="$DB_NAME"
fi
unset ans


###  create the tables  ###
###########################
read -p "setup table schema? (y/n): " ans
if [[ $ans = y ]]
then
    psql -d $DB_NAME -f sql/create_framework_tables.sql -U $USER
    psql -d $DB_NAME -f sql/create_functions.sql -U $USER
fi
unset ans


###  enable timescale extension  ###
####################################
read -p "enable timescaledb extension? (y/n): " res
if [[ $res = y ]]
then
    psql -d $DB_NAME -f sql/enable_timescale.sql -U $USER
fi
unset res


echo 'restarting postgresql service...'
sudo service postgresql restart
echo 'service restarted.'
echo 'configuration complete.'