#!/bin/bash
# Skrypt do przywracania systemu PlusWorkflow
# ścieżka docelowa restore
exec 19>>backup.log
if [[ ! -e backup.log ]] ; then
touch backup.log
fi
BASH_XTRACEFD=19
TIME=$(date +'%y-%m-%d')
set -x
echo
echo '*************************************************************************************************************'
echo '************************************************STATR RESTORE*************************************************'
echo '*************************************************************************************************************'
rozpakowywanie backupu
tar -xvf backups.tar
tar -xvf backups/system_PlusWorkflow/system-PlusWorkflow-${TIME}.tar.gz
#wskazywanie ścieżki instalacyjnej plusworkflow
echo -n "Wprowadź ścieżke do katalogu plusworkflow: "
read path
echo "plusworkflow jest zainstalowany w: $path"
#kopiowanie wypakowanych plikow do folderu instalacyjnego plusworkflow
cp -r home/plusworkflow/* $path
#
#############################
## POSTGRESQL konfiguracja ##
#############################
#
# adres serwera gdzie zainstalowany jest postgres
HOSTNAME=localhost
#
# port postgresa
PORT=5432
#
#nazwa bazy danych
DATABASENAME=plusworkflow
#
# uzytkownik do polaczenia z baza danych
USERNAME=postgres
#
# katalog gdzie zainstalowany jest postgres
POSTGRES_DIR=/usr/lib/postgresql/12
#
#nazwa backupu bazy danych
BACKUPNAME=${TIME}_PlusWorkflow_BAZA_DANYCH".backup"
#lokalizacja pliku z backupem bazy
BACKUP_DIR=backups/baza_danych_PlusWorkflow
#-------------------------------
restore() {
export PGPASSFILE=.pgpass
echo $PGPASSFILE
echo `$POSTGRES_DIR/bin/pg_restore -h $HOSTNAME -p $PORT --if-exist -w -U $USERNAME -d $DATABASENAME -c -v $BACKUP_DIR/$BACKUPNAME`;
}
#
#--------------------------------
restore
#
#echo 'plusworkflow stop prod'
#echo 'plusworkflow start prod'
echo '*************************************************************************************************************'
echo '*************************************************FINISH RESTORE**********************************************'
echo '*************************************************************************************************************'
echo;
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}