postgresql 12版本主備部署

環(huán)境搭建

centos 7+

postgresql 12.0

# 網(wǎng)絡(luò)檢查
ping -c2 baidu.com
#關(guān)閉防火墻，selinux
systemctl stop firewalld && sudo systemctl disable firewalld
sed -ri s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config
setenforce 0
### 配置阿里云yum源
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak
curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
#echo “isntalling tools”
yum -y install vim net-tools wget ntpdate
yum -y groupinstall “Development Tools”
# 時間同步
echo “*/10 * * * * /usr/sbin/ntpdate ntp.aliyun.com > /dev/null 2>&1” >>/etc/crontab
# 加快ssh連接
sed -ri s/”#UseDNS yes”/”UseDNS no”/g /etc/ssh/sshd_config
systemctl restart sshd
## 環(huán)境準備，根據(jù)自身需要，減少或者增加
yum install -y wget gcc gcc-c++ epel-release llvm5.0 llvm5.0-devel clang libicu-devel perl-ExtUtils-Embed readline readline-devel zlib zlib-devel openssl openssl-devel pam-devel libxml2-devel libxslt-devel openldap-devel systemd-devel tcl-devel python-devel
## 下載、解壓，安裝
cd /usr/local/src
wget https://ftp.postgresql.org/pub/source/v12.0/postgresql-12.0.tar.gz
tar -xvzf postgresql-12.tar.gz
cd postgresql-12
./configure –prefix=/usr/local/pgsql/12 –enable-nls –with-python –with-tcl –with-gssapi –with-icu –with-openssl –with-pam –with-ldap –with-systemd –with-libxml –with-libxslt
make && make install
## 創(chuàng)建目錄和用戶,以及配置環(huán)境變量
groupadd postgres
useradd -g postgres postgres
## 密碼設(shè)置在引號內(nèi)輸入自己的密碼
echo “postgres” | passwd –stdin postgres
mkdir -p /data/pgdata/{data,archivedir}
chown -R postgres:postgres /usr/local/pgsql -R
chown postgres:postgres /data/pgdata -R
echo “export PATH=/usr/local/pgsql/12/bin:$PATH” >/etc/profile.d/pgsql.sh
source /etc/profile.d/pgsql.sh