projects
/
edozvola
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
6b2a51d
)
reformat
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sat, 19 Aug 2017 09:30:50 +0000
(11:30 +0200)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sat, 19 Aug 2017 09:30:50 +0000
(11:30 +0200)
edozvola-dpavlin.txt
patch
|
blob
|
history
diff --git
a/edozvola-dpavlin.txt
b/edozvola-dpavlin.txt
index
38ef4e6
..
c6877e0
100644
(file)
--- a/
edozvola-dpavlin.txt
+++ b/
edozvola-dpavlin.txt
@@
-44,7
+44,8
@@
sending incremental file list
\r
\r
\r
\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
[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
@@
-54,66
+55,53
@@
test=# insert into test1 (a,b) values ('bar',1234) ;
INSERT 0 1
\r
\r
\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
[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
[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
[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
[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
[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
[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
[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
[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
[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
\r
\r
\r
\r
-podesiti wal archiving
\r
\r
\r
+# podesiti wal archiving
\r
\r
https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
\r
\r
\r
https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
\r
\r
@@
-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
\r
wal_level = replica
\r
archive_mode = on
\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
archive_command = 'test ! -f /shared/pgsql/%f && cp %p /shared/pgsql/%f'
\r
hot_standby = on
\r
\r