#!/bin/bash

# -- VERSION 0.80.03
# --  $Id: backup_all_sh.txt,v 1.2 2006/01/17 15:03:13 webcms Exp $

DBNAME=auctionline2002

#####  v============================v
#####  -- Customize begin

BINPATH=/usr/local/pgsql/bin
PGHOMEPATH=/home/postgres

#BINPATH=/usr/bin
#PGHOMEPATH=/var/lib/pgsql

#####  -- Customize end
#####  ^============================^

echo `/bin/date`

# -- YYYYMMDD:
mydate=`date +%Y%m%d`

mkdir $PGHOMEPATH/$DBNAME/$mydate-all

echo -n "DB Dump all to $PGHOMEPATH/$DBNAME/$mydate-all/$DBNAME.dump ... "
# -Z 5  =  compression; use .gz for file extension
$BINPATH/pg_dump -f "$PGHOMEPATH/$DBNAME/$mydate-all/$DBNAME.dump" $DBNAME

echo -n "done at "
echo `/bin/date`

cd $PGHOMEPATH/$DBNAME

echo -n "Dump was created on "  >> $mydate-all/readme.txt
echo `hostname`                 >> $mydate-all/readme.txt
echo -n "at "                   >> $mydate-all/readme.txt
echo `/bin/date`                >> $mydate-all/readme.txt

/bin/tar -czf $PGHOMEPATH/$DBNAME/$mydate-all.tar.gz $mydate-all
/bin/rm -Rf $PGHOMEPATH/$DBNAME/$mydate-all

# -- List last created backups
ls -lt $PGHOMEPATH/$DBNAME/*.tar.gz|head -5