安装一些系统包：

yum install -y gcc gcc-c++ automake autoconf libtool make gmake
yum install -y readline-devel
yum install -y zlib-devel

创建用户名：

groupadd postgres
useradd -g postgres -m postgres
passwd postgres

更新bash_profile

vi .bash_profile

export PGPORT=5432
export PGHOME=/u01/pgsql
export PGDATA=/u01/pgdata
export PATH=$PGHOME/bin:$PATH
export MANPATH=$PGHOME/share/man:$MANPATH
export LANG=en_US.utf8
export DATE=`date +"%Y-%m-%d %H:%M:%S"`
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH

编译安装

tar -zvxf postgresql-9.3.1.tar.gz
./configure --prefix=/u01/pgsql
make &&  make install

配置选项说明：

--prefix=/u01/pgsql：安装所有文件在/u01/pgsql中（取代默认时的/usr/local/pgsql）。
--with-pgport=5432：为服务器和客户端设置默认端口号。默认是5432。
--with-perl：编译PL/Perl服务端语言。
--with-python：编译PL/Python服务端语言。
--with-tcl：编译PL/Tcl服务端语言。
--with-openssl：编译支持SLL（加密）连接。这需要安装OpenSSL包。
--[......]

查看全文

         数据库集群所需要的所有数据都存储在集群的数据目录里， 通常用 PGDATA 来引用（用的是可以定义之的环境变量的名字）。 PGDATA 的一个常见位置是 /var/lib/pgsql/data。 

        PGDATA 目录包含几个子目录以及一些控制文件，除了这些必要的东西之外， 集群的配置文件 postgresql.conf，pg_hba.conf 和 pg_ident.conf 通常都存储在 PGDATA 。

查看全文

 

postgresql的内存说明：

 

 

shared_buffers (integer)

Sets the amount of memory the database server uses for shared memory buffers. The default is typically 128 megabytes (128MB), but might be less if your kernel settings will not support it (as determined duringinitdb). This setting must be at least 128 kilobytes. (Non-default values of BLCKSZ change the minimum.) However, settings significantly higher than the minimum are usually needed for good performance. This parameter can only be set at server start.

If you have a dedicated database server with 1GB or more of RAM, a reasonable starting value for shared_buffers is 25% of the memory in your system. There are some workloads where even large settings forshared_buffers are effective, but because PostgreSQL also relies on the operating system cache, it is unlikely that an allocation of more than 40% of RAM to sh[……]

查看全文