【メモ2】2011/05/16～17 PostgreSQL導入トレ - sarusaru36 @ ウィキ

■PostgresSQLのインストール用SELL「/tmp/setup/setup-intro.sh」
#! /bin/bash

set -e
 
version=9.0.0
arch=$(uname -i)
currdir=$(dirname $0)
 
killall postgres || :
sleep 5
 
rpm -qa | grep postgresql | xargs rpm -e --nodeps || :
 
chkconfig network off
chkconfig sendmail off
 
cp ${currdir}/bash_profile /tmp
mv /tmp/bash_profile /etc/skel/.bash_profile
 
if id postgres; then
	userdel postgres
	groupdel postgres || :
	rm -fr /var/lib/pgsql
fi
groupadd -r -g 26 -o postgres
useradd -c "PostgreSQL Server" -d /var/lib/pgsql -g postgres -m -r \
	-o -s /bin/bash -u 26 postgres
echo postgres | passwd --stdin postgres
 
cp ${currdir}/postgresql-${version}.tar.bz2 /usr/local/src
 
cp ${currdir}/pgsql-${version}-src.${arch}.tar.bz2 /tmp
if [ -d /usr/local/src/postgresql-${version} ]; then
	rm -fr /usr/local/src/postgresql-${version}
fi
tar -xjf /tmp/pgsql-${version}-src.${arch}.tar.bz2 -C /usr/local/src
chown -R postgres:postgres /usr/local/src/postgresql-${version}
 
cp ${currdir}/pgsql-${version}-bin.${arch}.tar.bz2 /tmp
if [ -d /usr/local/pgsql ]; then
	rm -fr /usr/local/pgsql
fi
tar -xjf /tmp/pgsql-${version}-bin.${arch}.tar.bz2 -C /usr/local
 
if [ -d /tmp/pgsql90-intro ]; then
	rm -fr /tmp/pgsql90-intro
fi
cp -r ${currdir}/pgsql90-intro /tmp
chown -R postgres:postgres /tmp/pgsql90-intro
 
 
 
■
#! /bin/bash

set -e
 
version=9.0.0
arch=$(uname -i)
currdir=$(dirname $0)
 
killall postgres || :
sleep 5
 
rpm -qa | grep postgresql | xargs rpm -e --nodeps || :
 
chkconfig network off
chkconfig sendmail off
 
cp ${currdir}/bash_profile /tmp
mv /tmp/bash_profile /etc/skel/.bash_profile
 
if id postgres; then
	userdel postgres
	groupdel postgres || :
	rm -fr /var/lib/pgsql
fi
groupadd -r -g 26 -o postgres
useradd -c "PostgreSQL Server" -d /var/lib/pgsql -g postgres -m -r \
	-o -s /bin/bash -u 26 postgres
echo postgres | passwd --stdin postgres
 
cp ${currdir}/postgresql-${version}.tar.bz2 /usr/local/src
 
cp ${currdir}/pgsql-${version}-src.${arch}.tar.bz2 /tmp
if [ -d /usr/local/src/postgresql-${version} ]; then
	rm -fr /usr/local/src/postgresql-${version}
fi
tar -xjf /tmp/pgsql-${version}-src.${arch}.tar.bz2 -C /usr/local/src
chown -R postgres:postgres /usr/local/src/postgresql-${version}
 
cp ${currdir}/pgsql-${version}-bin.${arch}.tar.bz2 /tmp
if [ -d /usr/local/pgsql ]; then
	rm -fr /usr/local/pgsql
fi
tar -xjf /tmp/pgsql-${version}-bin.${arch}.tar.bz2 -C /usr/local
cp ${currdir}/pgsql-${version}-data.${arch}.tar.bz2 /tmp
tar -xjf /tmp/pgsql-${version}-data.${arch}.tar.bz2 -C /usr/local/pgsql
chown -R postgres:postgres /usr/local/pgsql
 
if [ -d /tmp/pgsql90-admin ]; then
	rm -fr /tmp/pgsql90-admin
fi
cp -r ${currdir}/pgsql90-admin /tmp
chown -R postgres:postgres /tmp/pgsql90-admin