学习备忘录

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`