From: | "Matthew H(dot) North" <ctsmhn(at)cts(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Automation/scheduling of Backup stratetgy |
Date: | 2000-10-19 15:40:40 |
Message-ID: | GAEEKJDCHLDJJALCNALCCEOCCDAA.ctsmhn@cts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Galbavy | 2000-10-19 15:41:46 | binding to a specific IP address |
Previous Message | Alexander Tait Brotman | 2000-10-19 14:42:20 | pg7.0.2 on Sol8 |