shell postgresql create_db.sh.txt
5墨值下载
#!/bin/bash
# 部署过程相关目录
PG_SERVICE_FILE="pg12.service"
# postgres 环境变量
PGGROUP="postgres"
PGUSER="postgres"
PGHOME="/opt/pgsql"
PGDATA="/pgdata/12/data"
PG_HBA_CONF='pg_hba.conf'
PG_CONF='postgresql.conf'
PG_HBA_NET='192.168.150.0/24'
# 部署过程相关系统命令
CHMOD="/usr/bin/chmod"
CHOWN="/usr/bin/chown"
MKDIR="/usr/bin/mkdir"
SU="/usr/bin/su"
EGREP='/bin/egrep'
PSQL="${PGHOME}/bin/psql"
PASSWORD='1qaz@WSX'
echo "-------------------4.创建 PG 数据库"
echo
echo "-------------------4.1 创建 PG 数据库目录并改变改组"
${MKDIR} -p ${PGDATA}
${CHOWN} ${PGUSER}:${PGGROUP} ${PGDATA}
${CHMOD} 700 ${PGDATA}
echo
echo "-------------------4.2 创建 PG 数据库目录并改变改组"
${SU} - ${PGUSER} -c "initdb -D ${PGDATA} --locale C" > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "数据库创建失败!"
exit 1
fi
echo
echo "-------------------4.3 启动 PG 数据库"
${SU} - ${PGUSER} -c "pg_ctl start" > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "数据库启动失败!"
exit 1
fi
echo
echo "-------------------4.4 修改账号密码"
${SU} - ${PGUSER} -c "${PSQL} -c \"alter user ${PGUSER} with password '$
{PASSWORD}';\"" > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "修改密码失败！"
exit 1
fi
echo
echo "-------------------4.5 检查 PG 数据库状态"
${SU} - ${PGUSER} -c "pg_ctl status" > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "数据库启动后，状态异常!"
fi
echo
echo "-------------------4.6 关闭 PG 数据库"
${SU} - ${PGUSER} -c "pg_ctl stop" > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "数据库关闭失败!"
exit 1
fi
echo
echo "-------------------4.7 创建 PG 服务文件"
if [ ! -f "/usr/lib/systemd/system/${PG_SERVICE_FILE}" ];then
cat >/usr/lib/systemd/system/${PG_SERVICE_FILE}<<EOF
[Unit]
Description=PostgreSQL Database Server
[Service]
Type=forking
User=postgres
ExecStart=${PGHOME}/bin/pg_ctl start -D ${PGDATA} -l /tmp/logfile
ExecReload=${PGHOME}/bin/pg_ctl reload -D ${PGDATA}
ExecStop=${PGHOME}/bin/pg_ctl stop -D ${PGDATA} -l /tmp/logfile
ExecRestart=${PGHOME}/bin/pg_ctl restart -D ${PGDATA} -l /tmp/logfile
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=0
[Install]
WantedBy=multi-user.target
EOF
else
echo "创建 PG 服务文件失败!"
exit 1
fi
echo
echo "-------------------4.8 修改配置文件: pg_hba.conf"
${EGREP} ${PGUSER} ${PGDATA}/${PG_HBA_CONF} > /dev/null 2>&1
if [ $? -ne 0 ];then
echo "host all ${PGUSER} ${PG_HBA_NET} md5" >> ${PGDATA}/$
{PG_HBA_CONF}
else
echo "流复制已开通网络权限"
fi
echo
echo "-------------------4.9 加载 PG 服务文件"
systemctl daemon-reload
if [ $? -ne 0 ];then
echo "数据库服务加载失败!"
exit 1
fi
echo
echo "-------------------4.10 修改配置文件: postgreql.conf"
${EGREP} "^listen_addresses" ${PGDATA}/${PG_CONF} > /dev/null 2>&1
if [ $? -eq 0 ];then
echo "参数 listen_addresses : 已配置"
else
echo "listen_addresses = '0.0.0.0'" >> ${PGDATA}/${PG_CONF}
fi
of 3
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论