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