# 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