#!/bin/sh
#
# Preinstall script for PostgreSQL
#
# Written by Ronald Joe Record <rr@sco.com>
#

CMT="PostgreSQL Superuser Account" 
POM=/var/lib/pgsql

chkpgsq() {
    awk -F: '$1 == "postgres" { retval = 1 } END { exit retval }' $1
}

addgrppgsq() {
    groupadd postgres > /dev/null 2>&1
}

addusrpgsq() {
    useradd -g postgres -d $POM -s /bin/sh -c "$CMT" -m postgres
}

# Set postgres user's password to root's password
#setusrpass() {
#   SHAD=/etc/shadow
#   RPASS=`awk -F: '$1 == "root" { print $2 }' $SHAD`
#   YEAR=`date '+%Y'`
#   DATE=`date '+%j'`
#   NYRS=`expr $YEAR - 1970`
#   DAYS=`expr $NYRS \* 365 + $NYRS / 4`
#   TIME=`expr $DAYS + $DATE`
#   awk -F: '
#     BEGIN { sline = "postgres:'$RPASS:$TIME'::"; done = 0 }
#     $1 == "postgres" { print sline; done = 1; next }
#     { print }
#   ' < $SHAD > ${SHAD}-t$$
#   C1=`wc -l $SHAD | awk ' { print $1 } '`
#   C2=`wc -l ${SHAD}-t$$ | awk ' { print $1 } '`
#   C3=`expr $C1 + 1`
#   [ $C2 -eq $C3 ] && {
#       elapse=0
#       locked=0
#       while [ -f /etc/security/ia/.pwd.lock ]
#       do
#           sleep 1
#           elapse=`expr $elapse + 1`
#           [ $elapse -gt 30 ] && {
#               locked=1
#               break
#           }
#       done
#       if [ $locked -eq 0 ]
#       then
#           touch /etc/security/ia/.pwd.lock
#           chown root:sys /etc/security/ia/.pwd.lock
#           chmod 400 /etc/security/ia/.pwd.lock
#           cat ${SHAD}-t$$ > $SHAD
#           rm -f /etc/security/ia/.pwd.lock
#           /usr/sbin/creatiadb
#       else
#           passwd -l postgres
#           echo "Account postgres locked."
#       fi
#   }
#}

chkpgsq /etc/group && addgrppgsq
chkpgsq /etc/passwd && {
        addusrpgsq
#       setusrpass
        passwd -l postgres
}

PHM=`grep postgres /etc/passwd | awk ' BEGIN { FS=":" } { print $6 } '`
[ "$PHM" ] || {
  echo "Error: User postgres does not exist or home directory not set. Exiting."
  exit 1
}

[ -d $PHM ] || mkdir -p $PHM

echo "
PGLIB=/usr/lib/postgresql
PGDATA=$POM/data
USER=postgres
export PGLIB PGDATA USER" >> $PHM/.profile

# Clean up any pre-existing server log from a prior installation
[ -f $POM/server.log ] && rm -f $POM/server.log

# Reset ownership of pre-existing data from a prior installation
[ -d $POM ] && find $POM -print | xargs chown postgres:postgres

exit 0
