Instalacija PostgreSQL na Linux operativnom sistemu

Instalirana su tri servisa:
1. PostgreSQL (v. 9.6-3) sa paketima:



postgresql96-server
postgresql96-contrib
postgresql96-devel
- Memorija koju Postgres koristi je optimizovana sa PgTune aplikacijom na 3GB RAM-a
(/var/lib/pgsql/9.6/data/postgresql.conf).
#
#
#
#
#
DB Version: 9.6
OS Type: linux
DB Type: web
Total Memory (RAM): 3 GB
Number of Connections: 100
listen_address = '*'
max_connections = 100
shared_buffers = 768MB
effective_cache_size = 2304MB
work_mem = 7864kB
maintenance_work_mem = 192MB
min_wal_size = 1GB
max_wal_size = 2GB
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 4
- Otvoren je pristup za konektovanje na bazu sa mreže (/var/lib/pgsql/9.6/data/pg_hba.conf).
Ukoliko imate drugu lokalnu adresu promenite u ovom fajlu.
# “local” is for Unix domain socket connections only
local
all
all
trust
# IPv4 local connections:
host
all
all
127.0.0.1/32
trust
host
all
all
192.168.8.0/24
md5
# IPv6 local connections:
#host
all
all
::1/128
ident
- Lozinka za postgres korisnika za pristup bazi sa mreže:Balans-cg:
user: postgres
pass: ALBO#balanscg
Balans-bih:
user: postgres
pass: ALBO#balansbih
- Na otvoren port za postgres:
firewall-cmd –permanent –add-service=postgresql
firewall-cmd –reload
2. PgAgent (v. 3.4.0) sa paketima:


wxGTK.x86_64 wxGTK-devel.x86_64
wxWidgets-2.8.12
Pored standardne instalacije dodata je skripta za pokretanje servisa.
vim /etc/rc.d/init.d/pgagent
Molim Vas proverite PgAgent da li odgovara Vašim potrebama obzirom da nemamo
ranije iskustvo u koriščenju ovog servisa.
3. Samba Server (sa jednim deljenim direktorijumom)
Samba user za oba servera:
SMB user: balans_user
SMB Pass: quei6OhLua
- Instalirani paketi:
samba
samba-commons
cups-libs
policycoreutils-python
samba-client
- Share folder
mkdir /balans
chmod -R 777 /balans
chcon -R -t samba_share_t /balans/
semanage fcontext -a -t samba_share_t /balans/
setsebool -P samba_enable_home_dirs on
- Kreiranje korisnika i grupeuseradd balans_user
groupadd balanseri
usermod -G balanseri balans_user
chgrp -R balanseri /balans
smbpasswd -a balans_user
- Sadržaj dodat u /etc/samba/smb.conf je:
[balans]
comment = shared-directory
security = share
path = /balans
public = no
valid users = balans_user, @balanseri
writable = yes
browseable = yes
create mask = 0775
- Otvoren port za sambu
firewall-cmd –permanent –add-service=samba
firewall-cmd –reload