Automation/scheduling of Backup stratetgy
Automation/scheduling of Backup stratetgy
От:
Corne Scheepers - MWeb <CScheepers@mweb.com>
Дата:
Is it posible to schedule / automate a backup task and functions to execute at a pre-defined time at a pre-defined recurrence rate? Cornè Scheepers SQL DBA/Developer Mindport BIS 021 9150327
Re: Automation/scheduling of Backup stratetgy
От:
Michel Decima <michel.decima@rd.francetelecom.fr>
Дата:
>Is it posible to schedule / automate a backup task and functions to execute >at a pre-defined time at a pre-defined recurrence rate? yes, using the cron daemon and the commands pg_dump or pg_dumpall. The following entry in the postgres user crontab will backup the database every day at 03:01 AM in /dev/null (very usefull) 1 3 * * * /usr/local/pgsql/bin/pg_dumpall > /dev/null just look at man cron man crontab man pg_dumpall MD.