Re: How to create nightly backups in Linux

Andrus wrote:
> I'm bit new to Linux. I'm using white-box linux and Postgres 8.1.4
> How to create backups of database with unique name in every night ?
> Is there some script sample which can be called from /etc/crontab ?

I use the following Z-shell script.  Rewriting to bash should be
trivial (probably no changes after the first line).
Note that this differs from yours in that it uses pg_dumpall
and dumps everything.  You would want to change that...

-----------------------------------------------
#!/bin/zsh

# We prefer backing up to the SAN, but use the local
#  disk as a fallback if the SAN isn't available.
backupdir=/u3/SolisDBbackups
if [ -d /mnt/san/SOLIS-files/db_backups ]; then
    backupdir=/mnt/san/SOLIS-files/db_backups
fi

backupdate=$(date --iso-8601=minutes)
backupfile=${backupdir}/${backupdate}.dbtxt
echo "Backing up SOLIS databases to ${backupfile}.gz"
date
pg_dumpall -c | gzip >${backupfile}.gz
echo "Backup of SOLIS databases to ${backupfile}.gz done."
date
exit 0
--------------------------------------------

The crontab entry is:
-------------------------------------------
45 21 * * * /u3/SolisDBbackups/fullDump.zsh
-------------------------------------------

Hope this helps.
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.