pgpool updates

[edozvola] / edozvola-pgpool.txt

diff --git a/edozvola-pgpool.txt b/edozvola-pgpool.txt
index f311bf8..a080057 100644 (file)
--- 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\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
@@ -33,3 +34,26 @@ listen_addresses = '*'
 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