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