Re: how do you automate database backups? - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: how do you automate database backups?
Date
Msg-id 4368EAC9.7040508@ca.afilias.info
Whole thread Raw
In response to how do you automate database backups?  (Ferindo Middleton Jr <fmiddleton@verizon.net>)
List pgsql-admin
Ferindo Middleton Jr wrote:

> Are there tools available to automate backing up databases? I would
> like to setup my PostgreSQL install to automatically backup databases
> and save the file to specific location at specific times of the day
> with little to no user intervention... I'd like to know how to do this
> in both Windows and Linux. I imagine I could write some kind of script
> or something on my Linux server but I have absolutely no idea how to
> implement this on a computer running Windows.


On Linux, you'd do as you mentioned write a script to do the dump.
You'd schedule the script to run at the approriate time using cron.

--
Brad Nicholson  416-673-4106    bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.



pgsql-admin by date:

Previous
From: Ferindo Middleton Jr
Date:
Subject: how do you automate database backups?
Next
From: Robert Treat
Date:
Subject: Re: how do you automate database backups?