Hi,
I have a quick question about upgrading postgresql-server rpm from 9.3.4-1PGDG.rhel5 to 9.3.5-1PGDG.rhel5 on Centos 5.4.
As highlighted below, the 9.3.5 rpm seems to overwrite PGDATA variable at ~postgres/.bash_profile. We have our database at a different location and this breaks a lot of scripts and admins.
Is PGDATA from now on fixed at /var/lib/pgsql/version/data or is this maybe a bug slipped into this particular rpm? If the rpm is fine, how should we run the DB in a non-default directory?
cheers,
Rami Annala
Alava.fi
[server ~]$ rpm -q --scripts -p postgresql93-server-9.3.5-1PGDG.rhel5.i386.rpm
warning: postgresql93-server-9.3.5-1PGDG.rhel5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 442df0f8
preinstall scriptlet (using /bin/sh):
groupadd -g 26 -o -r postgres >/dev/null 2>&1 || :
useradd -M -n -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \
-c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || :
touch /var/log/pgsql
chown postgres:postgres /var/log/pgsql
chmod 0700 /var/log/pgsql
postinstall scriptlet (using /bin/sh):
chkconfig --add postgresql-9.3
/sbin/ldconfig
# postgres' .bash_profile.
# We now don't install .bash_profile as we used to in pre 9.0. Instead, use cat,
# so that package manager will be happy during upgrade to new major version.
echo "[ -f /etc/profile ] && source /etc/profile
PGDATA=/var/lib/pgsql/9.3/data
export PGDATA" > /var/lib/pgsql/.bash_profile
chown postgres: /var/lib/pgsql/.bash_profile
preuninstall scriptlet (using /bin/sh):
if [ $1 = 0 ] ; then
/sbin/service postgresql-9.3 condstop >/dev/null 2>&1
chkconfig --del postgresql-9.3
fi
postuninstall scriptlet (using /bin/sh):
/sbin/ldconfig
if [ $1 -ge 1 ]; then
/sbin/service postgresql-9.3 condrestart >/dev/null 2>&1
fi