Postgre+pgpool实现HA.docxVIP

PostgreSQL HA方案架构图方案架构图postgres故障切换图pgpool故障切换图pgpool+postgres故障切换图安装资源信息操作系统的安装就不在这里介绍，主机名和IP地址如下所示操作系统：RHEL 6.5数据库：PostgreSQL 9.4.4虚拟机两台：主节点node1(IP 192.168.1.231)备节点node2(IP 192.168.1.232)pgpool：pgpool-II-3.4.3VIP：192.168.1.233资源调整(master/standby)前期准备创建安装文件夹#mkdir /opt/soft//用于放置源码安装文件#mkdir /opt/pgdata//postgres数据库目录#mkdir /opt/pgsql//postgres安装目录#mkdir /opt/pgpool//pgpool安装目录修改文件夹权限#chownpostgres:postgres /opt/soft#chownpostgres:postgres /opt/pgsql#chownpostgres:postgres /opt/pgdata#chownpostgres:postgres /opt/pgpool复制以下安装文件到/opt/soft，并且配置权限pgpool-II-3.4.3.tar.gzpostgresql-9.4.4.tar.gz配置安装文件所属人和所属组为postgres关闭防火墙#chkconfigiptables off#service iptables stop关闭SElinux修改SELinux配置文件#vim /etc/sysconfig/selinux把SELINUX=enforcing修改为SELINUX=disabled配置hosts文件在hosts文件中增加以下内容#vim /etc/hosts192.168.1.231 pgpool-node01192.168.1.232 pgpool-node02创建postgres用户并设置密码安装之前要先检查系统中是否有postgres系统账号#cat /etc/passwd | grep postgres如果没有postgres账号，需要新增postgres账号#groupadd -g 26 postgres#useradd -d /var/lib/pgsql –g postgres –u 26postgres给postgres配置密码#passwdpostgres主备节点时钟同步#/usr/sbin/ntpdate asia.pool.ntp.org /sbin/hwclock –systohc配置sysctl#vi /etc/sysctl.confkernel.shmmni = 4096kernel.sem = 5010050100 1280fs.file-max = 7672460net.ipv4.ip_local_port_range = 9000 65000net.core.rmem_default = 1048576net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.tcp_tw_recycle = 1net.ipv4.tcp_max_syn_backlog = 4096net.core.netdev_max_backlog = 10000vm.overcommit_memory = 0net.ipv4.ip_conntrack_max = 655360fs.aio-max-nr = 1048576net.ipv4.tcp_timestamps = 0使文件修改生效#sysctl –plimit资源分配#vi /etc/security/limits.conf* soft nofile 131072* hard nofile 131072* soft nproc 131072* hard nproc 131072* soft core unlimited* hard core unlimited* soft memlock hard memlockostgreSQL流复制环境安装配置配置SSH免登陆On master:#su–postgres$ssh-keygen -t rsa -P $ssh-copy-id -i ~/.ssh/id_rsa.pub postgres@192.168.1.232$ssh postgres@node2On standby:#su–postgres$ssh-keygen -t