RucioUpdateToNewVersion

From GridPP Wiki
Jump to: navigation, search

Instructions To Update Rucio

Pre-steps

  1. Using the daily backup of DB02 move this to DB03 and apply the database
    1. Find the latest backup
grep  Transferred  /var/log/atlasbackup/atlasbackup.log | tail -1
    1. Retrieve the backup
[root@ruciodb02 ~]# tape -r csfserv <BackUpNumber> <location for backup>/tape.<BackUpNumber>
    1. Move the backup to DB03 using SCP if backup not availale
[root@ruciodb02 ~]# scp -i <Path/To/PrivateKey> /mnt/backfs/ruciodb02_db_backup_202108241613 root@ruciodb03.gridpp.rl.ac.uk:/var/lib/pgsql
    1. Move the tape backup to DB03
[root@ruciodb02 ~]# scp -i <Path/To/PrivateKey> <<location for backup>/tape.<BackUpNumber> root@ruciodb03.gridpp.rl.ac.uk:/var/lib/pgsql
    1. Unpack the tape backup
[root@ruciodb03 ~]# tar xf tape.<BackUpNumber>
    1. Find the database name on DB03
[root@ruciodb03 ~]# su postgres
bash-4.2$ psql
postgres-# \c 
You are now connected to database "<DB_Name>" as user "postgres".
postgres-# \q
bash-4.2$
    1. Drop the current database
bash-4.2$ dropdb <DB_Name>
    1. Create a new databse and apply backup
bash-4.2$ createdb -T template0 <DB_Name>
psql  -v  -d <DB_Name> -f  <Path/To/Backup>/ruciodb02_<ID> 

This process will take some time (between 40-60 mins)