hogeでログイン
cd ~hoge/src
fetch ftp://ftp.ring.gr.jp/pub/misc/db/postgresql-jp/7.2/postgresql-7.2.tar.gz
su -

pw groupadd -n postgres -g 5432
pw useradd -n postgres -u 5432 -d /home/postgres -g postgres -m -s /bin/csh -c "use postgresql"
cd /usr/local/src
zcat ~hoge/src/postgresql-7.2.tar.gz | tar -xvf -
cd postgresql-7.2
setenv CFLAGS "-O3 -mpentiumpro -march=pentiumpro"
./configure --enable-multibyte=EUC_JP --with-perl
/usr/local/bin/make -f Makefile all
/usr/local/bin/make -f Makefile install
cd src/interfaces/perl5
/usr/local/bin/make -f Makefile all
/usr/local/bin/make -f Makefile install
chown -R postgres /usr/local/pgsql
chgrp -R postgres /usr/local/pgsql
chown root /usr/local/pgsql/lib/
su - postgres

cat > .cshrc
set path = ( $path /usr/local/pgsql/bin )
setenv POSTGRES_HOME /usr/local/pgsql
setenv PGLIB $POSTGRES_HOME/lib
setenv PGDATA $POSTGRES_HOME/data
setenv LD_LIBRARY_PATH $PGLIB

source ~/.cshrc
initdb

vi /usr/local/pgsql/data/postgresql.conf
tcpip_socket = true
silent_mode = true
#max_connections = 64 # 1-1024
#shared_buffers = 128 # min 16

vi /usr/local/pgsql/data/pg_hba.conf
host       all         127.0.0.1     255.255.255.255    trust

cat > /usr/local/etc/rc.d/postgres.sh
#!/bin/sh
# pgsql
if [ -x /usr/local/pgsql/bin/pg_ctl -a -x /usr/local/pgsql/bin/postmaster ]; then
        echo -n 'postgres';
        rm -f /tmp/.s.PGSQL.5432
        su - postgres -c "pg_ctl -w start"
fi

chmod 700 /usr/local/etc/rc.d/postgres.sh

cat >> /etc/ld.so.conf
/usr/local/pgsql/lib/