PREIN

/bin/sh

/usr/share/rpm-helper/add-user postgresql $1 postgres /var/lib/pgsql /bin/bash 
if [ ! -e /var/log/postgresql ]; then
    touch /var/log/postgresql
fi
chown postgres.postgres /var/log/postgresql
chmod 0700 /var/log/postgresql

# large objects are not dumped by dumpall, so do nothing if we detect some
test_lo_db ()
{   
    su - postgres -c "psql -d template1 -At -F ' ' -c 'SELECT datname from pg_database WHERE datallowconn ORDER BY 1;'" | \
    while read DATABASE; do
	su - postgres -c "psql -d $DATABASE -A -F ' ' -c '\lo_list'" | grep -E '([0-9]+ row.?)' | (grep -q -v '(0 rows)' && return 0) || continue &> /dev/null
	return 0
    done
    return 1
}

fail_dump ()
{
   echo "ERROR migrating postgresql database"
   echo "Could not dump data from database"
   echo "You need to dump your data manually in order to update your postgresql database"
   echo ""
   exit 1
}

dump_data ()
{
    if cp -f /var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf.mdk_update && cp -f /usr/share/pgsql/pg_hba.conf.sample /var/lib/pgsql/data/pg_hba.conf; then
      service postgresql start
      if [ ! -f $file ]; then
# This does not work nicely, because pg_dumpall override -Fc and does not allow custom format dumping. As a consequence large objects are not dumped.
#        su - postgres -c "pg_dumpall -b -o -Fc > $file" &> /dev/null
         rm -rf /var/lib/pgsql/rpmtmp
         su - postgres -c "mkdir /var/lib/pgsql/rpmtmp"
         if ! su - postgres -c "pg_dumpall | gzip > $file"; then
 	   fail_dump
	 fi 
      else
        fail_dump 
      fi
      service postgresql stop
      cp -f /var/lib/pgsql/data/pg_hba.conf.mdk_update /var/lib/pgsql/data/pg_hba.conf
    fi
}

file=/var/lib/pgsql/rpmtmp/pg_dumpall-8.0.3-2mdk.psql.gz

if [[ $1 -ge 1 ]] && grep -vq 8.0 /var/lib/pgsql/data/PG_VERSION &> /dev/null; then
# the psql -c '\lo_list' does not work inside rpm script for version < 7.3
    if ! test_lo_db; then
        if [ -f /var/lock/subsys/postgresql ]; then
            service postgresql stop
	    dump_data
        else 
            dump_data
        fi
    fi
fi

PREUN

/bin/sh

/usr/share/rpm-helper/del-service postgresql $1 postgresql

POSTIN

/bin/sh

/sbin/ldconfig

restore_dump ()
{
    if cp -f /var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf.mdk_update; then
      if mv -f /var/lib/pgsql/data /var/lib/pgsql/initdb.i18n /var/lib/pgsql/rpmtmp/; then

# This does not work nicely, because pg_dumpall override -Fc and does not allow custom format dumping. As a consequence large objects are not dumped.
#       if service postgresql start && su - postgres -c "pg_restore -Fc -o -f $file" &> /dev/null; then 
        service postgresql start > /dev/null
        if [ -f /var/lock/subsys/postgresql ] && su - postgres -c "gzip -cd $file | psql template1" > /dev/null; then 
            mv -f /var/lib/pgsql/rpmtmp/initdb.i18n /var/lib/pgsql/rpmtmp/initdb.i18n.rpmsave &> /dev/null
            mv -f /var/lib/pgsql/rpmtmp/data/postmaster.opts /var/lib/pgsql/data/postmaster.opts.rpmsave &> /dev/null
            find /var/lib/pgsql/rpmtmp/data -name "*.conf" -exec mv -f {} {}.rpmsave \; -exec mv {}.rpmsave /var/lib/pgsql/data/ \;
            cp -f /var/lib/pgsql/rpmtmp/data/pg_hba.conf.mdk_update /var/lib/pgsql/data/pg_hba.conf
            rm -rf /var/lib/pgsql/rpmtmp
        else
            service postgresql stop
            rm -f $file /var/lib/pgsqlinitdb.i18n
            rm -rf /var/lib/pgsql/data
            mv -f /var/lib/pgsql/rpmtmp/data /var/lib/pgsql/rpmtmp/initdb.i18n /var/lib/pgsql/
            rmdir /var/lib/pgsql/rpmtmp &> /dev/null
        fi
      fi
    fi
}

file=/var/lib/pgsql/rpmtmp/pg_dumpall-8.0.3-2mdk.psql.gz

if grep -vq 8.0 /var/lib/pgsql/data/PG_VERSION &> /dev/null && [[ $1 -ge 1 && -f $file ]]; then
    if [ -f /var/lock/subsys/postgresql ]; then 
        service postgresql stop &> /dev/null
        restore_dump
        service postgresql start &> /dev/null
    else
        restore_dump
    fi
fi

/usr/share/rpm-helper/add-service postgresql $1 postgresql

POSTUN

/bin/sh

/sbin/ldconfig
/usr/share/rpm-helper/del-user postgresql $1 postgres