1 # odrađeno na serveru
\r
3 # Centos 7 x64 minimal install, zatim:
\r
4 yum install vim nano mlocate wget curl man epel-release telnet net-tools
\r
5 yum groupinstall 'Development tools'
\r
10 vim /etc/selinux/config # postavljen SELINUX=disabled
\r
12 systemctl stop firewalld
\r
13 systemctl disable firewalld
\r
17 vim /etc/hosts # u hosts dodano:
\r
19 10.200.1.60 edozvola-db-pgpool
\r
20 10.200.1.61 edozvola-db-01
\r
21 10.200.1.62 edozvola-db-02
\r
23 # dodan postgres 9.6 i pgpool 3.6.5 repo (zadnje stable verzije)
\r
24 yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
\r
25 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
\r
27 # instaliran postgres i pgpool (postgres je instaliran jer treba pgpool-u)
\r
28 #yum install postgresql96 postgresql96-server pgpool-II-96 pgpool-II-96-extensions
\r
29 # dpavlin -- zapravo ne trebju za pgpool-II-pg96 paket
\r
31 vim /etc/pgpool-II/pgpool.conf # u konfi je samo promijeno:
\r
33 listen_addresses = '*'
\r
38 # konfiguracija pgpool-II za read balancing
\r
40 http://www.pgpool.net/docs/latest/en/html/restrictions.html
\r
42 ## create data directory za back-end-e
\r
44 [root@edozvola-db-pgpool ~]# mkdir -v -p /var/lib/pgsql/edozvola-db-0{1,2}
\r
45 mkdir: created directory ‘/var/lib/pgsql/edozvola-db-01’
\r
46 mkdir: created directory ‘/var/lib/pgsql/edozvola-db-02’
\r
48 [root@edozvola-db-pgpool pgpool-II-96]# chmod 644 /usr/lib/systemd/system/pgpool-II-96.service
\r
49 [root@edozvola-db-pgpool pgpool-II-96]# systemctl enable pgpool-II-96
\r
50 [root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/run/pgpool/
\r
51 [root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/log/pgpool/
\r
52 [root@edozvola-db-pgpool pgpool-II-96]# systemctl start pgpool-II-96
\r
54 [root@edozvola-db-pgpool pgpool-II-96]# psql -c "show pool_nodes" --host edozvola-db-pgpool --user postgres template1
\r
57 http://www.pgpool.net/docs/latest/en/html/runtime-config-load-balancing.html
\r