本篇文章主要介绍了"电工学简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播 pgpool 简明使用jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播"，主要涉及到电工学简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播方面的内容，对于其他数据库感兴趣的同学可以参考一下：
一、系统环境172.16.3.226(master)172.16.3.228(slave)172.16.3.229(pgpool)# yum install -...
一、系统环境
172.16.3.226(master)
172.16.3.228(slave)
172.16.3.229(pgpool)
# yum install -y gcc-c++ zlib-devel readline-devel
# useradd postgres
# passwd postgres
Changing password for user postgres.
New password:
BAD PASSWORD: The password contains the user name in some form
Retype new password:
passwd: all authentication tokens updated successfully.
#
1.安装postgresql
# vi /etc/profile
export PATH=/opt/pgsql/10.0/bin:$PATH
export LD_LIBRARY_PATH=/opt/pgsql/10.0/lib
export MANPATH=/opt/pgsql/10.0/share/man:$MANPATH
[root@pgpool ~]#
# tar zxvf pgpool-II-3.6.6.tar.gz
# cd pgpool-II-3.6.6
# ./configure --prefix=/opt/pgpool/3.6.6 --sysc/pgpool/
# make
# make install
# cp src/redhat/pgpool.service /lib/systemd/system/
# chmod +x /lib/systemd/system/pgpool.service
# systemctl enable pgpool.service
#
# vi /lib/systemd/system/pgpool.service
[Unit]
Description=Pgpool-II
After=syslog.target network.target
Wants=network.target
[Service]
Type=forking
Envir/etc/sysconfig/pgpool
ExecStart=/opt/pgpool/3.6.6/bin/pgpool -f /etc/pgpool/pgpool.conf $OPTS
ExecStop=/opt/pgpool/3.6.6/bin/pgpool -f /etc/pgpool/pgpool.conf $STOP_OPTS stop
ExecReload=/opt/pgpool/3.6.6/bin/pgpool -f /etc/pgpool/pgpool.conf reload
[Install]
WantedBy=multi-user.target
#####################################################################
# chown postgres -R /opt/pgpool/3.6.6
# chown postgres -R /etc/pgpool/
# su - postgres
