```
#!/bin/bash
# Created at 2021/02/22
# Author CZH
# This Script used to set postgresql environment.
# reference : https://github.com/digoal/blog/blob/master/201608/20160803_01.md
# reference : https://github.com/digoal/blog/blob/master/201611/20161121_01.md
#
#   Scripts Summary
#   1.func_check_root: run as root
#   2.func_set_hostname: set hostname or not.
#   3.func_inst_pack: install os packages.
#   4.func_disable_selinux: disable selinux
#   5.func_set_sysctl: set os kernel parameters.
#   6.func_set_dirty: set write disk ratio.
#   7.func_set_limits: set user open file and stack limits.
#   8.func_os_other: disk scheduler and disable THP. 
#   9.func_set_datadir: mkdir data directory and user env.

# Exit this shell when any error occur.
set -e

# Configure Global variables.
v_curdate=`date +%Y%m%d_%H%M%S`
v_memtotal=`cat /proc/meminfo |grep MemTotal|awk '{print $2}'`

# check current user is root or not.
function func_check_root()
{
if [ ${UID} -ne 0 ]
    then
        echo -e "\nPlease use root run this scripts!\n"
        exit 0
    else
        echo -e "\n>>>>>>>> This script will run as root ! <<<<<<< 9.2的版本已大幅降低共享記憶體的使用
v_shmmax=`echo $(expr $(getconf _PHYS_PAGES) / 2 \* $(getconf PAGE_SIZE))`
# configure sysctl.conf
cat >> /etc/sysctl.conf <<eof kernel.shmall="${v_shmall}" kernel.shmmax="${v_shmmax}" kernel.shmmni="4096" vm.overcommit_memory="2" same="" as="" close="" oom.="" vm.overcommit_ratio="80" only="" take="" effect="" when="" overcommit_memory="" set="" to="" vm.swappiness="0" net.ipv4.ip_local_port_range="10000" kernel.sem="4096" kernel.sysrq="1" kernel.core_uses_pid="1" kernel.msgmnb="65536" kernel.msgmax="65536" kernel.msgmni="2048" kernel.core_pattern="/data/corefiles/core_%e_%u_%t_%s.%p" net.ipv4.tcp_syncookies="1" net.ipv4.conf.default.accept_source_route="0" net.ipv4.tcp_max_syn_backlog="4096" net.ipv4.conf.all.arp_filter="1" net.ipv4.tcp_keepalive_intvl="20" net.ipv4.tcp_keepalive_probes="3" net.ipv4.tcp_keepalive_time="60" net.ipv4.tcp_mem="8388608" net.ipv4.tcp_fin_timeout="5" net.ipv4.tcp_synack_retries="2" net.core.netdev_max_backlog="10000" the="" maximum="" receive="" socket="" buffer="" size="" in="" bytes="" net.core.rmem_max="4194303" send="" bytes.="" net.core.wmem_max="4194303" vm.zone_reclaim_mode="0" vm.dirty_expire_centisecs="3000" fdatasync="" vm.dirty_ratio="95" pdflush="" vm.dirty_writeback_centisecs="100" numa="" eof="" configure="" min="" reserved="" memory="" percent="" of="" total="" memory.="" awk="" .03="">> /etc/sysctl.conf
        echo -e "\nfunc func_set_sysctl execute Successful!\n"
}

# Configure os kernel dirty flush on the basis of physical memory.
# 大於64g則設定值，否則設定比率
function func_set_dirty()
{
if [ ${v_memtotal} -gt 67108864 ];then
    cat >>/etc/sysctl.conf <<eof vm.dirty_background_bytes="1610612736" vm.dirty_bytes="4294967296" eof="" else="" cat="">>/etc/sysctl.conf <<eof vm.dirty_background_ratio="3" vm.dirty_ratio="10" eof="" fi="" echo="" func_set_dirty="" execute="" successful="" configure="" limits.conf="" function="" func_set_limits="" cat="">> /etc/security/limits.d/20-nproc.conf <<eof postgres="" soft="" nofile="" hard="" nproc="" eof="" echo="" func_set_limits="" execute="" successful="" adjust="" disk="" i="" scheduler="" thp="" ssh="" user="" function="" func_os_other="" set="" scheduler.="" redhat="" and="" centos="" grubby="" disable="" transparent="" hugepage="" on="" rhel="" cat="" display="" grub="" modify="" maxsessions.="" sed="" maxs="" add="" greenplum="" administration="" group="" user.="" groupadd="" useradd="" userenv="" .bash_profile="" settings="" func_set_userenv="">> /home/postgres/.bash_profile
export PS1='[\u@\h] (\w) \$ '
export PGPORT=${v_port}
export PGDATA=${v_datadir}
export LANG=en_US.utf8
export PGHOME=/usr/local/postgres
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib
export PATH=$PGHOME/bin:$PATH
export DATE=`date +"%Y%m%d%H%M"`
export MANPATH=$PGHOME/share/man:$MANPATH
export PGHOST=$PGDATA
export PGUSER=postgres
export PGDATABASE=postgres
alias rm='rm -i'
alias ll='ls -lh'
unalias vi
EOF
}

func_set_hostname
func_check_root
func_inst_pack
func_disable_selinux
func_set_sysctl
func_set_dirty
func_set_limits
func_os_other
func_set_datadir
echo -e "\n>>>>>>>> The operating system setup is finished, please reboot! <<<<<<<
                        </eof></eof></eof></eof>

CentOS7.5安裝PostgreSQL作業系統配置指令碼

相關文章