Re: Re(2): Crontab and PostgreSQL Backup

On Fri, Oct 06, 2000 at 07:48:03PM +0800, pgsql-admin wrote:
> you can also try this:

or:

#!/bin/bash
PREFIX=/directory
DATABASE=db
rm -f $PREFIX.last
pg_dump -d $DATABASE -f $PREFIX.last
ln -f $PREFIX.last $PREFIX.hour.`date +%H`
ln -f $PREFIX.last $PREFIX.day.`date +%d`
ln -f $PREFIX.last $PREFIX.month.`date +%Y%m`

Run this every hour, and $PREFIX will contain backups for every hour for
the last day, every day for the last month and one backup for every
month.


--
Ragnar Kjørstad
Modus Media