PREIN

/bin/sh

/usr/share/rpm-helper/add-user postgresql9.0 $1 postgres /var/lib/pgsql /bin/bash 

[ ! -f /var/lib/pgsql/data/PG_VERSION ] && exit 0
mypgversion=`cat /var/lib/pgsql/data/PG_VERSION`
[ $mypgversion = 9.0 ] && exit 0

echo ""
echo "You currently have database tree for Postgresql $mypgversion"
echo "You must use postgresql${mypgversion}-server"
echo "To update you Postgresql server, dump your databases"
echo "delete /var/lib/pgsql/data/ content, upgrade the server, then"
echo "restore your databases from your backup"
echo ""

exit 1

PREUN

/bin/sh

/usr/share/rpm-helper/del-service postgresql9.0 $1 postgresql

POSTUN

/bin/sh

/usr/share/rpm-helper/del-user postgresql9.0 $1 postgres

POSTTRANS

/bin/sh

/usr/share/rpm-helper/add-service postgresql9.0 $1 postgresql