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
#!/bin/bash
# To be executed at the root of the project
# To upgrade from 0.0.5.9 to 0.0.6.2
sudo apt update
sudo apt -yy upgrade
sudo sed -i "s/buster/bullseye/g" /etc/apt/sources.list
sudo apt update
sudo apt -yy dist-upgrade
##############################################################
# BACKUP
sudo -i -u postgres bash << EOF
pg_dumpall > /tmp/backup.dump
EOF
##############################################################
sudo sed -i "s/bullseye/bookworm/g" /etc/apt/sources.list
sudo apt update
sudo apt -yy dist-upgrade
sudo apt install -y postgresql-14 libpq-dev
sudo apt remove --purge postgresql-11 postgresql-13
sudo apt autoremove
##############################################################
# BACKUP
sudo -i -u postgres bash << EOF
psql < /tmp/backup.dump
EOF
##############################################################
# DB CONFIG
sed -i "s/DB_PORT = 5432/DB_PORT = 5434/" gargantext.ini
# be sure the DB password is the right one
DBPASS=$(grep "DB_PASS" gargantext.ini | sed "s/^.*= //")
echo $DBPASS
sudo -i -u postgres psql << EOF
ALTER ROLE gargantua password '${DBPASS}';
EOF
##############################################################
# Make sure compilation is ok
git pull origin dev
./bin/install
##############################################################
# Database upgrade
echo "0.0.6.0 SQL upgrade"
./bin/psql gargantext.ini < devops/postgres/upgrade/0.0.6.0.sql
echo "0.0.6.1 SQL upgrade"
./bin/psql gargantext.ini < devops/postgres/upgrade/0.0.6.1.sql
echo "0.0.6.2 SQL upgrade"
./bin/psql gargantext.ini < devops/postgres/upgrade/0.0.6.2.sql
echo "Executing script haskell upgrade"
~/.local/bin/gargantext-upgrade gargantext.ini
echo "Upgrade is over"