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@xxxxxxxxxxxxxxx
Database Administrator, Afilias Canada Corp.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
