--- /dev/null
+# odrađeno na serveru\r
+\r
+# Centos 7 x64 minimal install, zatim:\r
+yum install vim nano mlocate wget curl man epel-release telnet net-tools\r
+yum groupinstall 'Development tools'\r
+yum update\r
+\r
+reboot\r
+\r
+vim /etc/selinux/config # postavljen SELINUX=disabled\r
+\r
+systemctl stop firewalld\r
+systemctl disable firewalld\r
+\r
+reboot\r
+\r
+vim /etc/hosts # u hosts dodano:\r
+\r
+10.200.1.60 edozvola-db-pgpool\r
+10.200.1.61 edozvola-db-01\r
+10.200.1.62 edozvola-db-02\r
+\r
+# kreiran LVM za /var/lib/pgsql\r
+fdisk /dev/sdb\r
+pvcreate /dev/sdb1\r
+vgcreate vg_pgsql /dev/sdb1\r
+lvcreate -l 100%FREE -n lv_pgsql vg_pgsql\r
+mkfs.xfs /dev/vg_pgsql/lv_pgsql\r
+mkdir /var/lib/pgsql\r
+mount /dev/vg_pgsql/lv_pgsql /var/lib/pgsql\r
+\r
+vim /etc/fstab # dodan mount point\r
+\r
+/dev/mapper/vg_pgsql-lv_pgsql /var/lib/pgsql xfs defaults 0 0\r
+\r
+reboot\r
+\r
+# dodan postgres 9.6\r
+yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm\r
+\r
+# instaliran postgres i postgis\r
+yum install postgresql96 postgresql96-contrib postgresql96-libs postgresql96-server postgis2_96 postgis2_96-client postgis2_96-utils\r
+\r
+# kreirana baza\r
+su postgres -c "/usr/pgsql-9.6/bin/initdb --lc-collate=hr_HR.utf8 -D /var/lib/pgsql/9.6/data/"\r
+\r
+vim /var/lib/pgsql/9.6/data/postgresql.conf # u konfi promijenjeno\r
+listen_addresses = '*'\r
+\r
+vim /var/lib/pgsql/9.6/data/pg_hba.conf # dodano:\r
+host all all 10.200.1.60/32 trust\r
+\r
+systemctl enable postgresql-9.6\r
+systemctl start postgresql-9.6\r
+ \r
+reboot
\ No newline at end of file
--- /dev/null
+# odrađeno na serveru\r
+\r
+# Centos 7 x64 minimal install, zatim:\r
+yum install vim nano mlocate wget curl man epel-release telnet net-tools\r
+yum groupinstall 'Development tools'\r
+yum update\r
+\r
+reboot\r
+\r
+vim /etc/selinux/config # postavljen SELINUX=disabled\r
+\r
+systemctl stop firewalld\r
+systemctl disable firewalld\r
+\r
+reboot\r
+\r
+vim /etc/hosts # u hosts dodano:\r
+\r
+10.200.1.60 edozvola-db-pgpool\r
+10.200.1.61 edozvola-db-01\r
+10.200.1.62 edozvola-db-02\r
+\r
+# dodan postgres 9.6 i pgpool 3.6.5 repo (zadnje stable verzije)\r
+yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm\r
+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
+\r
+vim /etc/pgpool-II/pgpool.conf # u konfi je samo promijeno:\r
+\r
+listen_addresses = '*'\r
+port = 5432\r
+\r
+reboot\r