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.
 
FAQ