DB and File restoration
DBs are usually restored in the local server (192.168.1.103) or any of the local machines (developers) for testing purpose.
The DBs are running on the postgres server in all the machines.
Example script for restoring a backup dump into sample database named "march_db07" is as follows.
pg_restore -h localhost -U origami_dbadmin -d march_db07 -W marchdb_10-11-2016.tar
where marchdb_10-11-2016.tar is the dump file.
DB admin user: origami_dbadmin
DB admin password: origami_dbadmin
The procedure is same as above in both local server and local machines.
============================================================[edit]
File restoration can be done by simply retrieving the files from archive DVDs and extracting the tarballs into the proper document root of the websites. (No specific details or procedure is needed here).
