电工学简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播 pgpool 简明使用jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播(2/6)

本篇文章主要介绍了"电工学简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播 pgpool 简明使用jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播"，主要涉及到电工学简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播方面的内容，对于其他数据库感兴趣的同学可以参考一下： 一、系统环境172.16.3.226(master)172.16.3.228(slave)172.16.3.229(pgpool)# yum install -...

[postgres@pgpool ~]$ cd /opt/pgpool/3.6.6/

[postgres@pgpool 3.6.6]$ mkdir log

# su - postgres

Last login: Mon Sep 11 15:08:36 CST 2017 on pts/1

[postgres@pgpool ~]$ 

[postgres@pgpool ~]$ 

[postgres@pgpool ~]$ cd /etc/pgpool/

[postgres@pgpool pgpool]$ mv pgpool.conf.sample-stream pgpool.conf

[postgres@pgpool pgpool]$ vi pgpool.conf

listen_addresses = '*'

port = 5432

# - Backend Connection Settings -

backend_hostname0 = '172.16.3.226'

                                   # Host name or IP address to connect to for backend 0

backend_port0 = 5432

                                   # Port number for backend 0

backend_weight0 = 1

                                   # Weight for backend 0 (only in load balancing mode)

backend_data_directory0 = '/pgdata10'

                                   # Data directory for backend 0

backend_flag0 = 'DISALLOW_TO_FAILOVER'

                                   # Controls various backend behavior

                                   # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER

backend_hostname1 = '172.16.3.228'

backend_port1 = 5432

backend_weight1 = 1

backend_data_directory1 = '/pgdata10'

backend_flag1 = 'DISALLOW_TO_FAILOVER'