linux下postgresql安装

1 添加用户 创建目录
  useradd postgres -d /usr/local/pgsql
  passwd postgres
  mkdir /usr/local/pgsql/
  mkdir /usr/local/pgsql/data
  chown -R postgres /usr/local/pgsql
  chown postgres /usr/local/pgsql/data
 
2 设置环境变量
  vi /etc/profile
  export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH
  export PATH=/usr/local/pgsql/bin:$PATH
  export PGDATA=/usr/local/pgsql/data
  export MANPATH=$MANPATH:/usr/local/pgsql/man

3 安装
   ./configure --prefix=/usr/local/pgsql ;make;make install

4 初始化数据库
  su postgres
  /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
 
5 添加开机自启动
  chmod a+x /tmp/postgresql-8.1.9/contrib/start-scripts/linux
  cp /tmp/postgresql-8.1.9/contrib/start-scripts/linux /etc/init.d/postgresql
  chkconfig --add postgresql

6 换数据库用户postgres的密码
  psql template1
  然后
  ALTER USER postgres WITH PASSWORD 'password';

7 添加外部的访问连接
  在pg_hba.conf加上
  host    all         all         192.168.1.104/32      md5
  启动
    /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &
or
    /usr/local/pgsql/bin/pg_ctl -i -D /usr/local/pgsql/data -l logfile start
  关闭   kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`