PG-源码编译安装

2021-10-27 03:57:46

 

1. 下载

-- 下载源码包
https://www.postgresql.org/download/product-categories/

源码下载地址：
https://ftp.postgresql.org/pub/source/v12.2/postgresql-12.2.tar.gz

有外网可以直接wget:
wget https://ftp.postgresql.org/pub/source/v12.2/postgresql-12.2.tar.gz

 

PG-源码编译安装

2. 环境配置

2.1 关闭防火墙

systemctl disable firewalld
systemctl stop  firewalld

2.2 关闭selinux

# 禁用selinux，配置/etc/sysconfig/selinux，修改SELINUX项为disabled
if [[ "$(getenforce)" = "Enforcing" ]]; then
    cp /etc/selinux/config{,_$(date +%Y%m%d)} && setenforce 0 && sed -i  "/^(SELINUX=.*)/c\#/1\nSELINUX=disable" /etc/selinux/config
fi

2.3 配置deadline IO调度

cat > /etc/udev/rules.d/60-postgres-schedulers.rules<<EOF
# postgres安装目录及数据目录所在磁盘
ACTION=="add|change", KERNEL=="sd[b-z]", ATTR{queue/rotational}=="0", ATTR{queue/scheduler}="deadline"
EOF

/usr/sbin/udevadm control --reload-rules

-- 检查确认
-- cat /sys/block/[sd*]/queue/scheduler 
cat /sys/block/sdb/queue/scheduler

2.4 添加用户

useradd -u 26 -r -c "PostgreSQL Server" -m postgres
passwd postgres
mkdir -p /ups/data/pgdata/11/pg_root
mkdir -p /ups/data/pgdata/11/pg_usr
mkdir -p /ups/data/pgdata/11/{pg_root,pg_usr,backups,scripts,archive_wals}
chown -R postgres:postgres /ups/data/pgdata
chmod 700 /ups/data/pgdata/11/{pg_root,pg_usr,backups,scripts,archive_wals}

-- /ups/data/pgdata/11/pg_root 目录存储数据库系统数据文件，
-- /ups/data/pgdata/11/pg_usr存储用户自定义表空间文件

2.5 配置用户环境变量

cat >> /home/postgres/.bash_profile<<-EOF
export PGPORT=1921
export PGUSER=postgres
export PGGROUP=postgres
export PGDATA=/ups/data/pgdata/11/pg_root
export LANG=en_US.UTF-8
export PGHOME=/ups/app/pgsql-11
export LD_LIBRARY_PATH=\$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib
export PATH=\$PGHOME/bin:\$PATH:.
export MANPATH=\$PGHOME/share/man:\$MANPATH
EOF

2.6 安装系统依赖包

# 检查
rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" systemd-devel gcc bison gcc-c++ flex readline  readline-devel zlib  zlib-devel \
perl  perl-devel make openssl-devel perl-ExtUtils-Embed perl-ExtUtils-MakeMaker libxml2-devel
# 安装
yum -y install systemd-devel gcc bison flex gcc-c++ readline  readline-devel  zlib  zlib-devel  perl \
perl-devel make openssl-devel perl-ExtUtils-Embed perl-ExtUtils-MakeMaker libxml2-devel

2.7 配置IPC

if [[ -f "/etc/systemd/logind.conf" ]]; then
    cp /etc/systemd/logind.conf /etc/systemd/logind.conf_$(date +%Y%m%d)
    sed -i "/#RemoveIPC=no/c\#RemoveIPC=no\nRemoveIPC=no" /etc/systemd/logind.conf
else
    cat > /etc/systemd/logind.conf << EOF
RemoveIPC=no
EOF
fi

2.8 huge page配置

# 样例
$ head -1 $PGDATA/postmaster.pid
4170
$ pmap 4170 | awk '/rw-s/ && /zero/ {print $2}'
6490428K
$ grep ^Hugepagesize /proc/meminfo
Hugepagesize:       2048 kB

6490428/2048=3170
$ sysctl -w vm.nr_hugepages=3170

 

3. 部署

3.1 解压

tar -xf postgresql-11.5.tar.gz -C /ups/app/
cd /ups/app/
mv postgresql-11.5 pgsql-11

3.2 编译安装

./configure --prefix=/ups/app/pgsql-11 --with-perl --with-libxml --with-openssl --with-systemd 
make world
make check
make install-world

以下4个配置不是必须的，但如果想修改必须要重新initdb

--with-segsize=1

表在操作系统上物理文件大小，单位GB，默认值为1，如果表大于1GB，将在操作系统上分割成多个1GB的文件。

--with-blocksize=32

块大小，单位KB,默认值为8，是表数据I/O和存储的单元，范围1-32，且必须是2的N次方。

--with-wal-segsize=32

WAL在操作系统上物理文件大小，单位MB，默认值16，范围1-64，且必须是2的N次方。

--with-wal-blocksize=64

WAL块大小，单位KB，是WAL I/O和存储的单元，范围1-64，且必须是2的N次方。

configure成功后，可以直接执行make命令进行简单编译，也可以执行make world将contrib目录下的扩展工具一起编译，当然也可以先进行简单编译，然后进入contrib下对某一工具进行单独编译

方法一：简单安装

1.执行命令

make && make install

命令执行完之后，pg软件就被安装到/opt/pg9.6路径下

 ls /opt/pg9.6/
bin include lib share

2.如果想安装contrib下的某一扩展工具，以检测数据库运行的pg_stat_statements为例

进入contrib/pg_stat_statements目录下（前提是已在主目录下执行了configure）

cd contrib/pg_stat_statements/

执行命令

 make && make install

 

方法二、全部安装（contrib下所有的扩展工具）

[root@localhost postgresql-9.6beta1]# make world && make install-world

3.3 初始化

su - postgres
/ups/app/pgsql-11/bin/initdb -D /ups/data/pgdata/11/pg_root
# 启动服务
pg_ctl -D /ups/data/pgdata/11/pg_root -l logfile start

PG-源码编译安装

3.4 配置参数

1）配置连接

export MDATE=$(date +"%Y%m%d%H")
-- 设置监听整个网络，查找“listen_addresses ”字符串
cp ${PGDATA}/postgresql.conf ${PGDATA}/postgresql.conf_${MDATE}
vi ${PGDATA}/postgresql.conf
-- 修改listen_addresses如下
listen_addresses = '*'

-- 配置连接方式
cp ${PGDATA}/pg_hba.conf ${PGDATA}/pg_hba.conf_${MDATE}
vi ${PGDATA}/pg_hba.conf
host    all             all             192.168.10.0/24           md5

2）配置共享内存

vi ${PGDATA}/postgresql.conf
shared_buffers = 128MB            # min 128kB      <<<<<<<<默认值

3）配置自启动服务

 

cat> /usr/lib/systemd/system/postgresql-11.service <<-EOF

# It's not recommended to modify this file in-place, because it will be

# overwritten during package upgrades.  If you want to customize, the

# best way is to create a file "/etc/systemd/system/postgresql-11.service",

# containing

#   .include /usr/lib/systemd/system/postgresql-11.service

#   ...make your changes here...

# For more info about custom unit files, see

# http://fedoraproject.org/wiki/Systemd#How_do_I_customize_a_unit_file.2F_add_a_custom_unit_file.3F

 

# Note: changing PGDATA will typically require adjusting SELinux

# configuration as well.

 

# Note: do not use a PGDATA pathname containing spaces, or you will

# break postgresql-setup.

[Unit]

Description=PostgreSQL 11 database server

Documentation=https://www.postgresql.org/docs/11/static/

After=syslog.target

After=network.target

 

[Service]

Type=notify

 

User=postgres

Group=postgres

 

# Note: avoid inserting whitespace in these Environment= lines, or you may

# break postgresql-setup.

 

# Location of database directory

Environment=PGDATA=/ups/data/pgdata/11/pg_root

 

# Where to send early-startup messages from the server (before the logging

# options of postgresql.conf take effect)

# This is normally controlled by the global default set by systemd

# StandardOutput=syslog

 

# Disable OOM kill on the postmaster

OOMScoreAdjust=-1000

Environment=PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj

Environment=PG_OOM_ADJUST_VALUE=0

 

# ExecStartPre=/ups/app/pgsql-11/bin/postgresql-11-check-db-dir \${PGDATA}

ExecStart=/ups/app/pgsql-11/bin/postmaster -D \${PGDATA}

ExecReload=/bin/kill -HUP \$MAINPID

KillMode=mixed

KillSignal=SIGINT

  

 

# Do not set any timeout value, so that systemd will not kill postmaster

# during crash recovery.

TimeoutSec=0

 

[Install]

WantedBy=multi-user.target

EOF

 

# 启动服务
systemctl start postgresql-11.service
systemctl status postgresql-11.service
systemctl enable postgresql-11.service

4）开启日志

# 开启日志
${PGDATA}/postgresql.conf

PG-源码编译安装

 

 

 

 

 

 

 

 

 

 

 

上一篇：如何给数据中心供配电


下一篇：UPS(Uninterrupted Power Supply)——不间断电源基础知识(转)