#!/bin/sh
# cb 010727

# setup
cd /home/tante/dump/ || exit 1
umask 077

# environment
PATH=/home/tante/bin:/usr/bin:/bin
DATE=`date '+%y%m%d-%H%M%S'`
KUNDEN="kunden-$DATE"
ARTIKEL="artikel-$DATE"

# get the password, dump tables to file
tante-pw | pg_dump -o -u -f "$KUNDEN"  -t kunden  tante 2>&1 | egrep -v '^$|Username: Password:'
tante-pw | pg_dump -o -u -f "$ARTIKEL" -t artikel tante 2>&1 | egrep -v '^$|Username: Password:'

# concatenate
cat "$ARTIKEL" >> "$KUNDEN"
rm "$ARTIKEL"

# compress
gzip -9 "$KUNDEN"

# do something with old backups
find . -name kunden\* -mtime +3 -print | xargs rm -f