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
\r
# instaliran postgres i pgpool (postgres je instaliran jer treba pgpool-u)\r
-yum install postgresql96 postgresql96-server pgpool-II-96 pgpool-II-96-extensions\r
+#yum install postgresql96 postgresql96-server pgpool-II-96 pgpool-II-96-extensions\r
+# dpavlin -- zapravo ne trebju za pgpool-II-pg96 paket\r
\r
vim /etc/pgpool-II/pgpool.conf # u konfi je samo promijeno:\r
\r
port = 5432\r
\r
reboot\r
+\r
+# konfiguracija pgpool-II za read balancing\r
+\r
+http://www.pgpool.net/docs/latest/en/html/restrictions.html\r
+\r
+## create data directory za back-end-e\r
+\r
+[root@edozvola-db-pgpool ~]# mkdir -v -p /var/lib/pgsql/edozvola-db-0{1,2}\r
+mkdir: created directory ‘/var/lib/pgsql/edozvola-db-01’\r
+mkdir: created directory ‘/var/lib/pgsql/edozvola-db-02’\r
+\r
+[root@edozvola-db-pgpool pgpool-II-96]# chmod 644 /usr/lib/systemd/system/pgpool-II-96.service\r
+[root@edozvola-db-pgpool pgpool-II-96]# systemctl enable pgpool-II-96\r
+[root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/run/pgpool/\r
+[root@edozvola-db-pgpool pgpool-II-96]# mkdir -p /var/log/pgpool/\r
+[root@edozvola-db-pgpool pgpool-II-96]# systemctl start pgpool-II-96\r
+\r
+[root@edozvola-db-pgpool pgpool-II-96]# psql -c "show pool_nodes" --host edozvola-db-pgpool --user postgres template1\r
+\r
+\r
+http://www.pgpool.net/docs/latest/en/html/runtime-config-load-balancing.html\r
+\r
+\r