Automation/scheduling of Backup stratetgy

Any word on when (if?) live/hot backup will be available?

Matthew H. North
Software Engineer
CTSnet Internet Services
t (858) 637-3600
f (858) 637-3630
mailto:ctsmhn(at)cts(dot)com

-----Original Message-----
From: pgsql-admin-owner(at)hub(dot)org [mailto:pgsql-admin-owner(at)hub(dot)org]On
Behalf Of Michel Decima
Sent: Thursday, October 19, 2000 6:04 AM
To: pgsql-admin(at)postgresql(dot)org; CScheepers(at)mweb(dot)com
Subject: Re: [ADMIN] Automation/scheduling of Backup stratetgy

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