1 # odrađeno na serveru
\r
3 # Centos 7 x64 minimal install, zatim:
\r
4 yum install vim nano mlocate wget curl man epel-release telnet net-tools
\r
5 yum groupinstall 'Development tools'
\r
10 vim /etc/selinux/config # postavljen SELINUX=disabled
\r
12 systemctl stop firewalld
\r
13 systemctl disable firewalld
\r
17 vim /etc/hosts # u hosts dodano:
\r
19 10.200.1.60 edozvola-db-pgpool
\r
20 10.200.1.61 edozvola-db-01
\r
21 10.200.1.62 edozvola-db-02
\r
23 # kreiran LVM za /var/lib/pgsql
\r
26 vgcreate vg_pgsql /dev/sdb1
\r
27 lvcreate -l 100%FREE -n lv_pgsql vg_pgsql
\r
28 mkfs.xfs /dev/vg_pgsql/lv_pgsql
\r
29 mkdir /var/lib/pgsql
\r
30 mount /dev/vg_pgsql/lv_pgsql /var/lib/pgsql
\r
32 vim /etc/fstab # dodan mount point
\r
34 /dev/mapper/vg_pgsql-lv_pgsql /var/lib/pgsql xfs defaults 0 0
\r
38 # dodan postgres 9.6
\r
39 yum install https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
\r
41 # instaliran postgres i postgis
\r
42 yum install postgresql96 postgresql96-contrib postgresql96-libs postgresql96-server postgis2_96 postgis2_96-client postgis2_96-utils
\r
45 su postgres -c "/usr/pgsql-9.6/bin/initdb --lc-collate=hr_HR.utf8 -D /var/lib/pgsql/9.6/data/"
\r
47 vim /var/lib/pgsql/9.6/data/postgresql.conf # u konfi promijenjeno
\r
48 listen_addresses = '*'
\r
50 vim /var/lib/pgsql/9.6/data/pg_hba.conf # dodano:
\r
51 host all all 10.200.1.60/32 trust
\r
53 systemctl enable postgresql-9.6
\r
54 systemctl start postgresql-9.6
\r