Dumping and Restoring Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> Database Dumping is a process of making a file containing <a href="/tag/sql/" target="_blank" class="keywords">sql</a> queries that can be used to contruct the whole database. Dumping is commonly used to download your database for backup or other purposes. Restoring is the reverse process of dumping. Dumping Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> Database To dump your Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> database you need to be logged on to your shell account. Please see the section called “Logging in to UNIX Shell Account” for more information about logging on shell account. Assuming your database name is u777_database,you need to use the following command to dump your Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> database. pg_dump -U u777_database u777_database / > u777_database.<a href="/tag/sql/" target="_blank" class="keywords">sql</a> That command should create a file named u777_database.<a href="/tag/sql/" target="_blank" class="keywords">sql</a> in the current directory. You can use FTP or other means to download the file. To make a gzip compressed dump file,you can use a few modification to the above command. pg_dump -U u777_database u777_database / | gzip > u777_database.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>.gz Restoring Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> Database To restore prev<a href="/tag/IoU/" target="_blank" class="keywords">IoU</a>sly dumped database you need to use p<a href="/tag/sql/" target="_blank" class="keywords">sql</a>. p<a href="/tag/sql/" target="_blank" class="keywords">sql</a> -U u777_database u777_database -f - / < u777_database.<a href="/tag/sql/" target="_blank" class="keywords">sql</a> Similarly,you can use the following command to restore Postgre<a href="/tag/sql/" target="_blank" class="keywords">sql</a> database when the dumped file is gzip compressed. gunzip < u777_database.<a href="/tag/sql/" target="_blank" class="keywords">sql</a> | / p<a href="/tag/sql/" target="_blank" class="keywords">sql</a> -U u777_database u777_database -f -

http://manual.intl.indoglobal.com/ch06s07.html