PG14安装脚本

Inkcup

#-------------------------------------------------------------------------
#运行本脚本前需上传安装包至/tmp
#-------------------------------------------------------------------------

#1.域名解析

cat >> /etc/hosts << EOF
192.168.133.112 test
EOF

#2.关闭防火墙

systemctl stop firewalld
systemctl disable firewalld

#3.关闭selinux

sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config

#4.安装依赖包

##配置本地yum源

mkdir /etc/yum.repos.d/bakrepo
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bakrepo

cat > /etc/yum.repos.d/localyum.repo<<EOF
[localyum]
name = localyum
baseurl = file:///mnt/
enabled = 1
gpgcheck = 0
EOF

#光驱文件版（和下面那个二选一）
mount -o loop /path/to/file.iso /mnt/

#挂载设备版
mount /dev/sr0 /mnt/

yum repolist all

##安装依赖包

yum  -y install make gcc tar readline readline-devel zlib zlib-devel icu libicu-devel perl python python-devel tcl tcl-devel gettext openssl openssl-devel openldap pam pam-devel lz4 lz4-devel zstd libzstd libzstd-devel flex bison libselinux libselinux-devel libxml2-devel libxslt libxslt-devel openldap-devel libuuid-devel systemd-devel vim


#5.配置资源限制

cat >>/etc/security/limits.conf <<EOF
postgres soft nofile 4096
postgres hard nofile 65536
postgres soft nproc 2048
postgres hard nporc 16384
postgres soft stack 10240
postgres hard stack 65536
EOF

#6.上传安装包
mkdir /software
mkdir -p /pg14/soft
mkdir -p /dbs/pg14/data

cp /tmp/postgresql-14.18.tar.gz /software/

#7.创建用户

useradd -u 2000 postgres
chown -R postgres:postgres /software /pg14 /dbs

#8.解压安装包
su - postgres
cd /software
tar -zxf postgresql-14.18.tar.gz
cd postgresql-14.18

#9.预编译检测
./configure --prefix=/pg14/soft --with-pgport=5432 --with-openssl --with-python --with-pam  --with-libxml --with-libxslt --enable-thread-safety

#10.执行编译安装

export COPT='-Werror'
make all -j4
make install -j4

#11.设置环境变量

cat >> /home/postgres/.bash_profile <<EOF
export LD_LIBRARY_PATH=/pg14/soft/exec/lib
export PATH=/pg14/soft/bin:\$PATH
export PGHOME=/pg14/soft
export PGDATA=/dbs/pg14/data
export PGPORT=5432
EOF

source /home/postgres/.bash_profile

#12.初始化数据目录
pg_ctl -D /dbs/pg14/data/ init

#13.启动数据库

pg_ctl start -D /dbs/pg14/data/ -l /tmp/logfile

#14.修改超级用户密码
psql
alter user postgres with password 'postgres';
exit