1
1
pg.sh.txt
5墨值下载
#!/bin/bash
# 部署过程相关目录
PG_INSTALL_FILE="/home/postgresql-12.8.tar.gz"
PG_MEDIA_PATH="/home/postgresql-12.8"
PG_INSTALL_PATH="/opt/pg12"
#PG_SERVICE_FILE="/usr/lib/systemd/system/pg12.service"
PG_SERVICE_FILE="pg12.service"
# postgres 环境变量
PG_PORT=1921
PGGROUP="postgres"
PGUSER="postgres"
PGHOME="/opt/pgsql"
PGDATA="/pgdata/12/data"
BASHRC='/home/postgres/.bashrc'
# 部署过程相关系统命令
GROUPADD="/usr/sbin/groupadd"
USERADD="/usr/sbin/useradd"
PASSWD="/usr/bin/passwd"
LN="/usr/bin/ln"
YUM="/usr/bin/yum"
TAR="/usr/bin/tar"
CHMOD="/usr/bin/chmod"
CHOWN="/usr/bin/chown"
GMAKE="/usr/bin/gmake"
MKDIR="/usr/bin/mkdir"
CP="/usr/bin/cp"
SU="/usr/bin/su"
# 修改的系统文件备份目录
BAK="/tmp/pg_install_bak"
# 修改的系统文件
LIMIT="/etc/security/limits.conf"
LOGIND="/etc/systemd/logind.conf"
echo
echo "-------------------1.配置主机环境"
echo
echo "-------------------1.1 创建备份目录"
if [ ! -d ${BAK} ];then
${MKDIR} ${BAK}
else
echo "DIR: ${BAK} exists"
exit 1
fi
echo
echo "-------------------1.2 安装前，备份修改的系统文件"
${CP} ${LIMIT} ${BAK}
${CP} ${LOGIND} ${BAK}
echo
echo "-------------------1.3 关闭防火墙"
systemctl stop firewalld
systemctl disable firewalld
echo
echo "-------------------1.4 关闭 selinux"
grep "^SELINUX=disabled" /etc/selinux/config > /dev/null 2>&1
if [ $? -eq 1 ];then
sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config > /dev/null
2>&1
fi
setenforce 0 > /dev/null 2>&1
echo
echo "-------------------1.5 配置资源限制"
grep "^# postgres limit" ${LIMIT} > /dev/null 2>&1
if [ $? -eq 0 ];then
cat >> /etc/security/limits.conf <<EOF
# postgres limit
* soft nofile 1024000 # The maximum number of open file descriptors
* hard nofile 1024000
* soft nproc unlimited # The maximum number of processes available to a single
user
* hard nproc unlimited
* soft memlock unlimited # The maximum size that may be locked into memory
* hard memlock unlimited
* soft core unlimited # The maximum size of core files created
* hard core unlimited
* soft stack unlimited
* hard stack unlimited
EOF
fi
echo
echo "-------------------1.6remove IPC"
grep "^RemoveIPC=no" /etc/systemd/logind.conf > /dev/null 2>&1
if [ $? -eq 1 ];then
echo "RemoveIPC=no" >> /etc/systemd/logind.conf
fi
systemctl restart systemd-logind.service
echo
echo "-------------------2.开始安装 PG"
echo
echo "-------------------2.1 安装 PG 依赖包"
${YUM} groupinstall -y "Development tools" > /dev/null 2>&1
${YUM} install -y bison flex readline-devel zlib-devel > /dev/null 2>&1
echo
echo "-------------------2.2 解压 PG 安装包"
${TAR} -xvf ${PG_INSTALL_FILE} -C /home/ > /dev/null 2>&1
echo
echo "-------------------2.3 修改解压包属组与权限"
${CHOWN} -R root:root ${PG_MEDIA_PATH} > /dev/null 2>&1
${CHMOD} -R 755 ${PG_MEDIA_PATH} > /dev/null 2>&1
echo
echo "-------------------2.4 配置 PG 安装包"
cd ${PG_MEDIA_PATH} > /dev/null 2>&1
./configure --prefix=${PG_INSTALL_PATH} --with-pgport=${PG_PORT} > /dev/null
2>&1
if [ $? -ne 0 ];then
echo "pg configure execute err"
exit 1
fi
echo
echo "-------------------2.5 编译 PG 安装包"
cd ${PG_MEDIA_PATH}
${GMAKE} -j 4 world > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "execute: pg gmake world error"
exit 1
fi
echo
echo "-------------------2.6 安装 PG 安装包"
${GMAKE} install-world > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "execute: pg gmake install-world error"
exit 1
fi
echo
echo "-------------------2.7 创建 PG 安装包链接文件"
${LN} -s ${PG_INSTALL_PATH} ${PGHOME} > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "execute: pg ln error"
exit 1
fi
echo
echo "-------------------3.配置 PG 环境"
echo
echo "-------------------3.1 创建系统账号 - postgres"
id ${PGUSER} > /dev/null 2>&1
if [ $? -ne 0 ];then
${GROUPADD} -g 11921 ${PGGROUP} > /dev/null 2>&1
${USERADD} -g 11921 -u 11921 ${PGUSER} > /dev/null 2>&1
echo '!QAZ2wsx' | ${PASSWD} --stdin ${PGUSER} > /dev/null 2>&1
else
echo "user: postgres exists"
exit 1
fi
echo
echo "------------------ 3.2 配置环境变量"
if [ -f ${BASHRC} ];then
echo "# postgres env" >> ${BASHRC}
echo "export PGHOME=/opt/pgsql" >> ${BASHRC}
echo "export PGDATA=/pgdata/12/data" >> ${BASHRC}
echo "export PATH=\$PATH:/opt/pgsql/bin" >> ${BASHRC}
echo "export PGPORT=1921" >> ${BASHRC}
echo "export PGUSER=postgres" >> ${BASHRC}
echo "export LD_LIBRARY_PATH=\
$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib" >>
of 4
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
文档被以下合辑收录
相关文档
评论