fusionpbx-docs/source/getting_started/restore.rst

*********
Restore
*********


It's always good to have a restore method of a backup in place.  Here are the steps to a basic restore method with FusionPBX.

.. Note:: It is important to know if your installation is from package or source as the paths are different for FreeSWITCH.  Always test the backups and restore methods on test machines first.

*  To create the script use an editor such as vi or nano.
*  Copy/Paste from the code block below and save the file as fusionpbx-restore.sh
*  Replace zzz with your database password
*  chmod + x fusionpbx-restore.sh and then run the script ./fusionpbx-restore.sh
*  edit the script as needed and run this script from the server you are restoring on.


::

 #!/bin/sh
 now=$(date +%Y-%m-%d)
 ssh_server=x.x.x.x
 database_host=127.0.0.1
 database_port=5432
 export PGPASSWORD="zzz"

 #run the remote backup
 ssh -p 22 root@$ssh_server "nice -n -20 /etc/cron.daily/./fusionpbx-backup.sh"

 #delete freeswitch logs older 7 days
 find /var/log/freeswitch/freeswitch.log.* -mtime +7 -exec rm {} \;

 #synchronize the backup directory
 #rsync -avz -e 'ssh -p 22' root@$ssh_server:/var/backups/fusionpbx /var/backups
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/var/backups/fusionpbx/postgresql /var/backups/fusionpbx
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/var/www/fusionpbx /var/www
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/etc/fusionpbx /etc
 find /var/backups/fusionpbx/postgresql -mtime +2 -exec rm {} \;

 rsync -avz -e 'ssh -p 22' root@$ssh_server:/etc/freeswitch/ /etc
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/var/lib/freeswitch/storage /var/lib/freeswitch
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/var/lib/freeswitch/recordings /var/lib/freeswitch
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/usr/share/freeswitch/scripts /usr/share/freeswitch
 rsync -avz -e 'ssh -p 22' root@$ssh_server:/usr/share/freeswitch/sounds /usr/share/freeswitch
 
 echo "Restoring the Backup"
 #extract the backup from the tgz file
 #tar -xvpzf /var/backups/fusionpbx/backup_$now.tgz -C /

 #remove the old database
 psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'drop schema public cascade;'
 psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'create schema public;'
 #restore the database
 pg_restore -v -Fc --host=$database_host --port=$database_port --dbname=fusionpbx --username=fusionpbx /var/backups/fusionpbx/postgresql/fusionpbx_pgsql_$now.sql

 #restart freeswitch
 service freeswitch restart
 echo "Restore Complete";