基础工具包安装,修改阿里镜像源
yum install -y wget mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo yum clean all yum makecache
selinux
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config setenforce 0
防火墙
systemctl stop firewalld systemctl disable firewalld
java
mkdir -p /data/pkg/ mkdir -p /data/app/ mkdir -p /data/app/logs mkdir -p /data/app/bin chown -R userapp:userapp /data put jdk-8u202-linux-x64.tar.gz /data/pkg/ cd /data/app/ tar -xvzf ../pkg/jdk-8u202-linux-x64.tar.gz cat <> /etc/profile export PATH=/data/app/bin:$PATH export JAVA_HOME=/data/app/jdk1.8.0_202 export PATH=$JAVA_HOME/bin:$PATH export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar EOF cat /etc/profile . /etc/profile
postgres
put postgresql-10.7-1-linux-x64-binaries.tar.gz /data/pkg/ mkdir -p /data/app/db cd /data/app/db tar -xvzf ../../pkg/postgresql-10.7-1-linux-x64-binaries.tar.gz mkdir /data/pkg/db/pg_data cat <> /etc/profile export APP_PATH=/data/app export PG_HOME=${APP_PATH}/pgsql export PGDATA=${APP_PATH}/pg_data export PATH=${PATH}:${PG_HOME}/bin EOF cat /etc/profile . /etc/profile # 初始化数据库 ${APP_PATH}/pgsql/bin/initdb -D ${APP_PATH}/pg_data
pg_配置文件修改
# 放开监听范围
sed -i 's/#listen_addresses = '''localhost'''/listen_addresses = '''*'''/g' ${APP_PATH}/pg_data/postgresql.conf
# 增加外部链接权限
mv ${APP_PATH}/pg_data/pg_hba.conf ${APP_PATH}/pg_data/pg_hba.conf_bak
awk '{ print $0 ;if($0 == "# IPv4 local connections:"){print "host all all 0.0.0.0/0 md5" } } ' ${APP_PATH}/pg_data/pg_hba.conf_bak > ${APP_PATH}/pg_data/pg_hba.conf
psql 启停脚本
cat </data/app/bin/pg_cmd . /etc/profile case $1 in start) ${APP_PATH}/pgsql/bin/pg_ctl -D ${APP_PATH}/pg_data -l ${APP_PATH}/logs/postgres.log start ;; stop) ${APP_PATH}/pgsql/bin/pg_ctl -D ${APP_PATH}/pg_data -l ${APP_PATH}/logs/postgres.log stop ;; restart) ${APP_PATH}/pgsql/bin/pg_ctl -D ${APP_PATH}/pg_data -l ${APP_PATH}/logs/postgres.log restart ;; *) echo "$0 {start|stop|restart}" ;; esac EOF chmod +x /data/app/bin/pg_cmd
新建数据库
psql postgres -e <



