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