From: Matko Jun <matko.jun@king-ict.hr>
Date: Sat, 19 Aug 2017 09:00:24 +0000 (+0200)
Subject: konfiguracija masina
X-Git-Url: http://git.rot13.org/?p=edozvola;a=commitdiff_plain;h=a079b3d1735f4a871ee43030ba2511214a3c77ed

konfiguracija masina
---

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