projects
/
edozvola
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
cleanup docs, extract scripts for postgresql
[edozvola]
/
edozvola-dpavlin.txt
diff --git
a/edozvola-dpavlin.txt
b/edozvola-dpavlin.txt
index
c6877e0
..
c248649
100644
(file)
--- a/
edozvola-dpavlin.txt
+++ b/
edozvola-dpavlin.txt
@@
-1,4
+1,7
@@
-yum install etckeeper
\r
+# instalirati etckeeper da čuva /etc/ direktorij u git-u
\r
+# (nije na produkcijskom enviromentu)
\r
+
\r
+yum install etckeeper
\r
cd /etc/
\r
git config --global user.email "dpavlin@rot13.org"
\r
git config --global user.name "Dobrica Pavlinusic"
\r
cd /etc/
\r
git config --global user.email "dpavlin@rot13.org"
\r
git config --global user.name "Dobrica Pavlinusic"
\r
@@
-26,7
+29,7
@@
bash-4.2$ cp -v .ssh/id_rsa.pub .ssh/authorized_keys
‘.ssh/id_rsa.pub’ -> ‘.ssh/authorized_keys’
\r
\r
\r
‘.ssh/id_rsa.pub’ -> ‘.ssh/authorized_keys’
\r
\r
\r
-prekopirati isti kljuc i authoriorized keys na slave:
\r
+
##
prekopirati isti kljuc i authoriorized keys na slave:
\r
\r
\r
[root@edozvola-db-01 pgsql]# rsync -rav .ssh edozvola-db-02:`pwd`
\r
\r
\r
[root@edozvola-db-01 pgsql]# rsync -rav .ssh edozvola-db-02:`pwd`
\r
@@
-108,40
+111,27
@@
https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
\r
[root@edozvola-db-01 ~]# vi /var/lib/pgsql/9.6/data/postgresql.conf
\r
wal_level = replica
\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 = 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
-
\r
\r
\r
+# https://www.postgresql.org/docs/9.6/static/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT
\r
+synchronous_commit = on
\r
\r
\r
+archive_mode = on
\r
+archive_command = 'test ! -f /shared/pgsql/%f && cp %p /shared/pgsql/%f'
\r
\r
\r
+max_wal_senders = 3
\r
+max_replication_slots = 3
\r
\r
\r
+hot_standby = on
\r
\r
\r
[root@edozvola-db-01 ~]# systemctl restart postgresql-9.6.service
\r
\r
\r
\r
\r
\r
[root@edozvola-db-01 ~]# systemctl restart postgresql-9.6.service
\r
\r
\r
\r
+# kreirati replication korisnika
\r
\r
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-
\r
-kreirati replication korisnika
\r
[root@edozvola-db-01 ~]# sudo -u postgres psql
\r
\r
[root@edozvola-db-01 ~]# sudo -u postgres psql
\r
\r
-
\r
postgres=# create user replication with password 'replication123' login replication ;
\r
CREATE ROLE
\r
\r
postgres=# create user replication with password 'replication123' login replication ;
\r
CREATE ROLE
\r
\r
@@
-151,15
+141,13
@@
CREATE ROLE
\r
host replication replication 10.200.1.62/24 md5
\r
\r
\r
host replication replication 10.200.1.62/24 md5
\r
\r
-
\r
-netmask je /24 da mozemo imati istu konfiguraciju na oba node-a
\r
+## netmask je /24 da mozemo imati istu konfiguraciju na oba node-a
\r
\r
\r
\r
\r
\r
\r
\r
\r
\r
\r
-
\r
-testirati replikaciju
\r
+# testirati replikaciju
\r
[root@edozvola-db-01 ~]# sudo -u postgres psql test
\r
test=# insert into test1 (a,b) values ('baz',3);
\r
INSERT 0 1
\r
[root@edozvola-db-01 ~]# sudo -u postgres psql test
\r
test=# insert into test1 (a,b) values ('baz',3);
\r
INSERT 0 1
\r
@@
-231,26
+219,22
@@
archive_cleanup_command = 'pg_archivecleanup /shared/pgsql %r'
\r
\r
\r
\r
\r
\r
-skripte
\r
-promoviranje slave-a u master
\r
+# skripte
\r
\r
\r
[root@edozvola-db-01 pgsql]# pwd
\r
/var/lib/pgsql
\r
\r
\r
[root@edozvola-db-01 pgsql]# pwd
\r
/var/lib/pgsql
\r
-[root@edozvola-db-01 pgsql]# cat promote-slave-to-master.sh
\r
-#!/bin/sh -xe
\r
-
\r
\r
\r
\r
\r
+## promoviranje slave-a u master
\r
\r
\r
+[root@edozvola-db-01 pgsql]# cat promote-slave-to-master.sh
\r
+#!/bin/sh -xe
\r
/usr/pgsql-9.6/bin/pg_ctl --pgdata=/var/lib/pgsql/9.6/data promote
\r
\r
\r
/usr/pgsql-9.6/bin/pg_ctl --pgdata=/var/lib/pgsql/9.6/data promote
\r
\r
\r
+## kreiranje slave instance od mastera
\r
\r
\r
-
\r
-
\r
-
\r
-kreiranje slave instance od mastera
\r
[root@edozvola-db-01 pgsql]# cat create-pgsql-slave.sh
\r
#!/bin/sh -e
\r
\r
[root@edozvola-db-01 pgsql]# cat create-pgsql-slave.sh
\r
#!/bin/sh -e
\r
\r