Re: Automation/scheduling of Backup stratetgy

From: Michel Decima <michel(dot)decima(at)rd(dot)francetelecom(dot)fr>
To: <pgsql-admin(at)postgresql(dot)org>, <CScheepers(at)mweb(dot)com>
Subject: Re: Automation/scheduling of Backup stratetgy
Date: 2000-10-19 13:04:20
Message-ID: 19340913063604.23462@p-grive.issy.cnet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message nataraj 2000-10-19 13:59:07 Re: help
Previous Message Corne Scheepers - MWeb 2000-10-19 09:21:13 Automation/scheduling of Backup stratetgy