基于上一篇的yum安装postgresql,这次分享一下基于源码安装postgresql的方法.

1 首先安装依赖

yum groupinstall -y "Development Tools" "Legacy UNIX Compatibility"
yum install -y bison flex readline* zlib-devel gcc* gmake

2 创建对应目录并授权

mkdir -p /usr/local/pg12
mkdir -p /pgdata/12/data
chown -R postgres. /pgdata
chown -R postgres. /usr/local/pg12
chmod 700 /pgdata/12/data -R

3 对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
加载配置
sysctl -p

vi /etc/security/limits.conf
* soft nofile 131072
* hard nofile 131072
* soft nproc 131072
* hard nproc 131072
* soft core unlimited
* hard core unlimited
* soft memlock 50000000
* hard memlock 50000000
建议关闭numa，设置IO策略为deadline(机械)或者noop(SSD)

4 软件安装

# tar xf postgresql-12.6.tar.gz
# cd postgresql-12.6
# ./configure --prefix=/usr/local/pg12 --with-pgport=1921
# gmake world
# gmake install-world

5 设置环境变量

# su - postgres
$ vim .bash_profile
export PGDATA=/pgdata/12/data
export LANG=en_US.utf8
export PGHOME=/usr/local/pg12
export LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH
export DATE=`date +"%Y%m%d%H%M"`
export PATH=$PGHOME/bin:$PATH:.
export MANPATH=$PGHOME/share/man:$MANPATH
export PGUSER=postgres
$ source .bash_profile
[postgres@pg1 ~]$ psql --version
psql (PostgreSQL) 12.6

6 初始化数据

# 简易初始化
initdb -D /pgdata/12/data -W
# 生产建议
initdb -A md5 -D $PGDATA -E utf8 --locale=C -W

7 启动数据库

[postgres@pg1 ~]$ pg_ctl -D /pgdata/12/data/ start -l logfile

源码安装就算完成了,是不是感觉很简单!那就开始愉快的玩耍PG吧