Thread: Automation/scheduling of Backup stratetgy

Automation/scheduling of Backup stratetgy

From
Corne Scheepers - MWeb
Date:
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

From
Michel Decima
Date:
>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.