postgresql notes

function installpostgresql() {
apt-get update
# needed for postgresql-contrib
apt-get -y install libxslt
apt-get -y remove postgresql
VERSION=8.2.3
PV=1PGDG
# change rhel-as-4 to rhel-es-3 for rhel3/whitebox3
URL=ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v$VERSION/linux/rpms/redhat/rhel-as-4
PACKAGES="postgresql-plpython postgresql-plperl postgresql-libs postgresql-contrib postgresql postgresql-server"
for PACKAGE in $PACKAGES; do
FILE=$PACKAGE-$VERSION-$PV.i686.rpm
if [ -e "$FILE" ] ; then
echo "Skipping $FILE, already have it"
continue
fi
echo "Fetching $URL/$FILE"
wget --no-verbose "$URL/$FILE"
if [ $? -ne 0 ] ; then
echo "Failed getting $URL/$FILE"
return 1
fi
done
# need -i - i.e. keep the old one - on this one to avoid dependency issues with dovecot and php-pgsql
rpm -i postgresql-libs-$VERSION*i686.rpm
# the rest can just be -U - i.e. upgrade any other packages
rpm -Uvfh postgresql-plpython-$VERSION-$PV.i686.rpm postgresql-plperl-$VERSION-$PV.i686.rpm  postgresql-contrib-$VERSION-$PV.i686.rpm postgresql-$VERSION-$PV.i686.rpm postgresql-server-$VERSION-$PV.i686.rpm
if [ $? -ne 0 ] ; then
echo "Failed installing rpms"
return 1
fi
chkconfig --level 35 postgresql on
/etc/init.d/postgresql start
psql --version
}
installpostgresql

cat /etc/cron.d/backupfsn.sh
#!/bin/bash
backup_dir="/var/log/"
timeslot=`date +%u`
i=dbnametobackup
/usr/bin/pg_dump -U postgres $i | gzip > "$backup_dir/postgresql-$i-$timeslot-database.gz"

psql  -U postgres -q -c "l" dbname | sed -n 4,/eof/p | grep -v rows) | awk {'print $1'}

rpm -Uvh "http://downloads.rimuhosting.com/dovecot-0.99.11-4-pg81.EL4.i386.rpm"