Re: [GENERAL] Backup up database

On Thu, 17 Sep 1998, Brian wrote:

> I am wanting to make a nightly dump/backup of our database in case
> something happens to it.  I'll probably run the backup right before I
> vacuum each night.
> 
> Is their a command I can type that will dump the entire database, complete
> with relations and data, so that if something did happen to it, It could
> be 100% restored?
> 
> Brian

pg_dump dbname > database.dump

Then, to restore,

psql -f database.dump template

(you can use any db you have access to in place of "template")


Simon.


> 
> 
> --------------------------------------------------------------------------
> Brian Feeny (BF304)   | ShreveNet Inc. - Premium Internet Service Provider 
> Network Administrator | Shreveport, Louisiana - http://www.shreve.net/
> signal@shreve.net     | Web Hosting, Virtual Domains, Storefronts, 
> (318)222-2NET x 109   | Database/Web Integration, 56k, ISDN, T1
> 
> 

-- 
                           ...oooOOOooo...
   Simon Drabble                     mailto:madlather@syspac.com   
   http://fiddletrudge.dyn.ml.org/  
   KreatAPayj           --        ~simon/KreatAPayj/login.html  
   LizardCam            --        LizardCam/LizardCam.html       
   Linux Knowledge Base --        ~simon/LinuxKB/index.html