http://kb.owrench.com/index.php?action=history&feed=atom&title=DB_and_File_restoration 2026-05-04T04:23:21Z Revision history for this page on the wiki MediaWiki 1.34.2 http://kb.owrench.com/index.php?title=DB_and_File_restoration&diff=72&oldid=prev 2016-11-17T06:28:05Z

<p>Created page with &quot;DBs are usually restored in the local server (192.168.1.103) or any of the local machines (developers) for testing purpose. &lt;br&gt; The DBs are running on the postgres server in...&quot;</p> <p><b>New page</b></p><div>DBs are usually restored in the local server (192.168.1.103) or any of the local machines (developers) for testing purpose.<br /> &lt;br&gt;<br /> The DBs are running on the postgres server in all the machines.<br /> &lt;br&gt;<br /> <br /> Example script for restoring a backup dump into sample database named &quot;march_db07&quot; is as follows.<br /> &lt;br&gt;<br /> '''pg_restore -h localhost -U origami_dbadmin -d march_db07 -W marchdb_10-11-2016.tar'''<br /> &lt;br&gt;<br /> &lt;br&gt;<br /> where marchdb_10-11-2016.tar is the dump file.<br /> &lt;br&gt;<br /> DB admin user: origami_dbadmin<br /> DB admin password: origami_dbadmin<br /> &lt;br&gt;<br /> &lt;br&gt;<br /> <br /> The procedure is same as above in both local server and local machines.<br /> <br /> ========================================================================<br /> <br /> 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).<br /> <br /> [[category:it-support]]</div>

imported>Kishor