centos7+java+postgres测试jdbc环境搭建

基础工具包安装,修改阿里镜像源

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  <<EOF >> /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  <<EOF >> /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  <<EOF > /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 <<EOF
\l
EOF


psql postgres -e <<EOF
CREATE  DATABASE  test_db;
CREATE USER  user_name  WITH PASSWORD 'pass_word';
GRANT ALL PRIVILEGES ON DATABASE test_db TO user_name   ;
\l
EOF