1.安装编译所需要的rpm包

• yum install -y readline readline-devel openssl openssl-devel zlib zlib-devel gcc*

2.编译安装

• /configure —prefix=/opt/postgres/soft
• make & make install

3.创建用户，修改环境变量3.创建用户，修改环境变量

• groupadd postgres
• useradd -g postgres postgres
• cat .bash_profile
  export PGHOME=/opt/postgres/soft
  export PGDATA=/opt/postgres/data
  export PATH=$PGHOME/bin:$PATH

4. 创建postgres数据库目录

• mkdir -p /opt/postgres/data
• chown -R postgres:postgres /opt/postgres

5.调整linux内核参数

• vi /etc/sysctl.conf
• kernel.shmmax = 68719476736 (默认)
• kernel.shmall = 4294967296 (默认)
• kernel.shmmni = 4096
• kernel.sem = 50100 64128000 50100 1280
• fs.file-max = 7672460
• net.ipv4.ip_local_port_range = 9000 65000
• net.core.rmem_default = 1048576
• net.core.rmem_max = 4194304
• net.core.wmem_default = 262144

• net.core.wmem_max = 1048576

  http://www.cndba.cn/tzq_131517/article/3515
  http://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515
  http://www.cndba.cn/tzq_131517/article/3515

• vi /etc/security/limits.confhttp://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515http://www.cndba.cn/tzq_131517/article/3515

• • soft nofile 131072
• • hard nofile 131072
• • soft nproc 131072
• • hard nproc 131072
• • soft core unlimited
• • hard core unlimited
• • soft memlock 50000000
• • hard memlock 50000000

6.初始化数据库

• initdb -D $PGDATA -E UTF8 —locale=C -U postgres -W

7.据库的启停

• pg_ctl start -D $PGDATA
• pg_ctl stop -m fast|smart|immediate -D $PGDATA

版权声明：本文为博主原创文章，未经博主允许不得转载。

简易安装postgresql