GitLab - Upgrade, backup and restore

gistfile1.txt

sudo apt upgrade -y
sudo apt install curl openssh-server ca-certificates postfix -y
curl -sS https://packages.gitlab.com/install/repositories/gitlab/gitlab-ce/script.deb.sh | sudo bash
sudo apt-get install gitlab-ce=11.7.5-ce.0
sudo gitlab-ctl reconfigure
sudo apt-get install gitlab-ce=11.11.0-ce.0
sudo gitlab-ctl reconfigure
sudo apt-get install gitlab-ce

vi /etc/gitlab/gitlab.rb
sudo gitlab-ctl reconfigure

sudo gitlab-ctl renew-le-certs

# cd /var/opt/gitlab/git-data/
# tar -czvf repositories.tar.gz repositories

$ su - gitlab-psql
$ export PGHOST=/var/opt/gitlab/postgresql
$ psql -l
                                         List of databases
        Name         |    Owner    | Encoding | Collate |  Ctype  |        Access privileges        
---------------------+-------------+----------+---------+---------+---------------------------------
 gitlab              | gitlab      | UTF8     | C.UTF-8 | C.UTF-8 | 
 gitlabhq_production | gitlab      | UTF8     | C.UTF-8 | C.UTF-8 | 
 postgres            | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | 
 template0           | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | =c/"gitlab-psql"               +
                     |             |          |         |         | "gitlab-psql"=CTc/"gitlab-psql"
 template1           | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | =c/"gitlab-psql"               +
                     |             |          |         |         | "gitlab-psql"=CTc/"gitlab-psql"
(5 rows)

# sudo gitlab-ctl reconfigure
# sudo gitlab-ctl restart