postgresql-資料
1.下載ver=9.1.3 ;cd /app; wgethttp://ftp.postgresql.org/pub/source/v$ver/postgresql-$ver.tar.gz ；
2.安裝-1#/bin/sh
ver=9.1.3
cp /app/sysctl.conf /etc
rm -r /usr/local/pgsql
rm -r /usr/src/postgresql*
mkdir /usr/local/pgsql
cd /usr/src/
tar -zxvf /app/postgresql-$ver.tar*
groupadd pgsql_user
useraddpgsql_user -g pgsql_user
mkdir /home/pgsql_user
chown -R pgsql_user /home/pgsql_user
chown -R pgsql_user:pgsql_user/usr/local/pgsql
chown -R pgsql_user:pgsql_user/usr/src/pgsql
cp /app/bash_profile /home/pgsql_user/.bash_profile
mkdir /etc/rc.d/run
cp /app/rc.d/run/* /etc/rc.d/run
chmod 755 /etc/rc.d/run/*
login pgsql_user
3.安裝-2
#!/bin/sh
cd /usr/src/postgresql*
./configure --enable-odbc --prefix=/usr/local/pgsql --enable-multibyte --enable-locale
make;make install;
cd /usr/src/pgsql/doc
make install;
initdb
cp /lin_app/pg_hba.conf /usr/local/pgsql/data
postgres -D /usr/local/pgsql/data &
createuser admin
createuser pgsql4.執行-- /etc/rc.d/rc.pgsql#!/bin/sh
#
# /etc/rc.d/rc.pgsql:Local system initialization script.
#
# Put any local setup commands in here:
echo "Start Postgres SQL Server........"
if [ -x /tmp/.s.PGSQL.5432 ]; then
rm /tmp/.s.PGSQL.5432
fi
su pgsql_user -c 'exec /usr/local/pgsql/bin/postmaster -i -D/usr/local/pgsql/data &'
页:
[1]