Automation/scheduling of Backup stratetgy - Mailing list pgsql-admin

From Matthew H. North
Subject Automation/scheduling of Backup stratetgy
Date
Msg-id GAEEKJDCHLDJJALCNALCCEOCCDAA.ctsmhn@cts.com
Whole thread Raw
List 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@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.



pgsql-admin by date:

Previous
From: nataraj
Date:
Subject: Re: help
Next
From: "Peter Galbavy"
Date:
Subject: binding to a specific IP address