Re: how do you automate database backups?

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.