X-Git-Url: http://git.rot13.org/?p=edozvola;a=blobdiff_plain;f=edozvola-pgpool.txt;fp=edozvola-pgpool.txt;h=a080057ad1dbfc03d4c22a04cd70461814b29a33;hp=f311bf8bb1881edf38f8d5f04b2f79358e1ccd88;hb=b5dc37d8c3114c6393773468e8905ae78e39e58b;hpb=7f8f68213f0611b293561aef0fab51f597b24731

diff --git a/edozvola-pgpool.txt b/edozvola-pgpool.txt
index f311bf8..a080057 100644
--- a/edozvola-pgpool.txt
+++ b/edozvola-pgpool.txt
@@ -25,7 +25,8 @@ yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.
 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
+#yum install postgresql96 postgresql96-server pgpool-II-96 pgpool-II-96-extensions
+# dpavlin -- zapravo ne trebju za pgpool-II-pg96 paket
 
 vim /etc/pgpool-II/pgpool.conf # u konfi je samo promijeno:
 
@@ -33,3 +34,26 @@ 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]# chmod 644 /usr/lib/systemd/system/pgpool-II-96.service
+[root@edozvola-db-pgpool pgpool-II-96]# systemctl enable pgpool-II-96
+[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-II-96
+
+[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
+
+