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@cts.com
-----Original Message-----
From: pgsql-admin-owner@hub.org [mailto:pgsql-admin-owner@hub.org]On
Behalf Of Michel Decima
Sent: Thursday, October 19, 2000 6:04 AM
To: pgsql-admin@postgresql.org; CScheepers@mweb.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.