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

From Michel Decima
Subject Re: Automation/scheduling of Backup stratetgy
Date
Msg-id 19340913063604.23462@p-grive.issy.cnet.fr
Whole thread Raw
In response to Automation/scheduling of Backup stratetgy  (Corne Scheepers - MWeb <CScheepers@mweb.com>)
List 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.


pgsql-admin by date:

Previous
From: Corne Scheepers - MWeb
Date:
Subject: Automation/scheduling of Backup stratetgy
Next
From: nataraj
Date:
Subject: Re: help