From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 19 Aug 2017 09:30:50 +0000 (+0200)
Subject: reformat
X-Git-Url: http://git.rot13.org/?p=edozvola;a=commitdiff_plain;h=a4bd3c62f64524aea3ef82cf443455b546931f03

reformat
---

diff --git a/edozvola-dpavlin.txt b/edozvola-dpavlin.txt
index 38ef4e6..c6877e0 100644
--- a/edozvola-dpavlin.txt
+++ b/edozvola-dpavlin.txt
@@ -44,7 +44,8 @@ sending incremental file list
 
 
 
-kreirati testnu bazu i tablicu
+# kreirati testnu bazu i tablicu
+
 [root@edozvola-db-01 ~]# sudo -u postgres createdb test
 [root@edozvola-db-01 ~]# sudo -u postgres psql test
 test=# create table test1 ( id serial, a text, b int ) ;
@@ -54,66 +55,53 @@ test=# insert into test1 (a,b) values ('bar',1234) ;
 INSERT 0 1
 
 
-nfs share za wal fileove
+
+# nfs share za wal fileove
+
 [root@edozvola-db-pgpool ~]# yum install nfs-utils nfs4-acl-tools
 [root@edozvola-db-pgpool ~]# systemctl enable nfs-server.service
 Created symlink from /etc/systemd/system/multi-user.target.wants/nfs-server.service to /usr/lib/systemd/system/nfs-server.service.
 [root@edozvola-db-pgpool ~]# systemctl start nfs-server.service
 
-
 [root@edozvola-db-pgpool ~]# mkdir -p /shared/pgsql
 [root@edozvola-db-pgpool ~]# chown postgres /shared/pgsql/
 
-
 [root@edozvola-db-pgpool ~]# vi /etc/exports
 
-
 [root@edozvola-db-pgpool ~]# cat /etc/exports
 /shared/pgsql edozvola-db-01(rw,no_root_squash) edozvola-db-02(rw,no_root_squash)
 
-
 [root@edozvola-db-pgpool ~]# exportfs -va
 exporting edozvola-db-01:/shared/pgsql
 exporting edozvola-db-02:/shared/pgsql
 
 
-mount na database serverima
+
+# mount na database serverima
+
 [root@edozvola-db-01 ~]# yum install nfs-utils nfs4-acl-tools
 [root@edozvola-db-01 ~]# mkdir -p /shared/pgsql
 [root@edozvola-db-01 ~]# vi /etc/fstab
 
-
 [root@edozvola-db-01 ~]# grep shared /etc/fstab
 edozvola-db-pgpool:/shared/pgsql        /shared/pgsql   nfs     defaults        0 0
 
-
 [root@edozvola-db-01 ~]# mount /shared/pgsql/
 
-
-provjeriti da li postgresql korisnik moze pisati po nfs share-u
-
+## provjeriti da li postgresql korisnik moze pisati po nfs share-u
 
 [root@edozvola-db-01 ~]# sudo -u postgres touch /shared/pgsql/test-01
 [root@edozvola-db-01 ~]# ls -al /shared/pgsql/test-01
 -rw-r--r-- 1 postgres postgres 0 Aug 18 13:57 /shared/pgsql/test-01
 [root@edozvola-db-01 ~]# rm -f /shared/pgsql/test-01
 
-
-isto ponoviti na edozvola-db-02!
-
-
-
-
-
-
-
-
+## isto ponoviti na edozvola-db-02!
 
 
 
 
-podesiti wal archiving
 
+# podesiti wal archiving
 
 https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
 
@@ -121,8 +109,8 @@ https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
 [root@edozvola-db-01 ~]# vi /var/lib/pgsql/9.6/data/postgresql.conf
 wal_level = replica
 archive_mode = on
-max_wal_senders = 1 
-max_replication_slots = 1
+max_wal_senders = 3 
+max_replication_slots = 3
 archive_command = 'test ! -f /shared/pgsql/%f && cp %p /shared/pgsql/%f'
 hot_standby = on