# odrađeno na serveru

# Centos 7 x64 minimal install, zatim:
yum install vim nano mlocate wget curl man epel-release telnet net-tools
yum groupinstall 'Development tools'
yum update

reboot

vim /etc/selinux/config # postavljen SELINUX=disabled

systemctl stop firewalld
systemctl disable firewalld

reboot

vim /etc/hosts # u hosts dodano:

10.200.1.60	edozvola-db-pgpool
10.200.1.61	edozvola-db-01
10.200.1.62	edozvola-db-02

# dodan postgres 9.6 i pgpool 3.6.5 repo (zadnje stable verzije)
yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
yum install http://www.pgpool.net/yum/rpms/3.6/redhat/rhel-7-x86_64/pgpool-II-pg96-3.6.5-1pgdg.rhel7.x86_64.rpm

# instaliran postgres i pgpool (postgres je instaliran jer treba pgpool-u)
#yum install postgresql96 postgresql96-server pgpool-II-96 pgpool-II-96-extensions
# dpavlin -- zapravo ne trebju postgresql96-server i pgpool-II-96* jer imamo pgpool-II-pg96 paket

vim /etc/pgpool-II/pgpool.conf # u konfi je samo promijeno:

listen_addresses = '*'
port = 5432

reboot

# konfiguracija pgpool-II za read balancing

http://www.pgpool.net/docs/latest/en/html/restrictions.html

## create data directory za back-end-e

[root@edozvola-db-pgpool ~]# mkdir -v -p /var/lib/pgsql/edozvola-db-0{1,2}
mkdir: created directory ‘/var/lib/pgsql/edozvola-db-01’
mkdir: created directory ‘/var/lib/pgsql/edozvola-db-02’

[root@edozvola-db-pgpool pgpool-II-96]# systemctl enable pgpool
[root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/run/pgpool/
[root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/log/pgpool/
[root@edozvola-db-pgpool pgpool-II-96]# systemctl start pgpool

[root@edozvola-db-pgpool pgpool-II-96]# psql -c "show pool_nodes" --host edozvola-db-pgpool --user postgres template1


http://www.pgpool.net/docs/latest/en/html/runtime-config-load-balancing.html