File tree Expand file tree Collapse file tree 1 file changed +46
-0
lines changed Expand file tree Collapse file tree 1 file changed +46
-0
lines changed Original file line number Diff line number Diff line change
1
+ #! /bin/sh
2
+
3
+ reinit_master () {
4
+ rm -rf install/data
5
+
6
+ ./install/bin/initdb -A trust -D ./install/data
7
+
8
+ echo " max_prepared_transactions = 100" >> ./install/data/postgresql.conf
9
+ echo " shared_buffers = 512MB" >> ./install/data/postgresql.conf
10
+ echo " fsync = off" >> ./install/data/postgresql.conf
11
+ echo " log_checkpoints = on" >> ./install/data/postgresql.conf
12
+ echo " max_wal_size = 48MB" >> ./install/data/postgresql.conf
13
+ echo " min_wal_size = 32MB" >> ./install/data/postgresql.conf
14
+ echo " wal_level = logical" >> ./install/data/postgresql.conf
15
+ echo " wal_keep_segments = 64" >> ./install/data/postgresql.conf
16
+ echo " max_wal_senders = 2" >> ./install/data/postgresql.conf
17
+ echo " max_replication_slots = 2" >> ./install/data/postgresql.conf
18
+
19
+ echo ' ' > ./install/data/logfile
20
+
21
+ echo ' local replication stas trust' >> ./install/data/pg_hba.conf
22
+
23
+ ./install/bin/pg_ctl -sw -D ./install/data -l ./install/data/logfile start
24
+ ./install/bin/createdb stas
25
+ ./install/bin/psql -c " create table t(id int);"
26
+ }
27
+
28
+ reinit_slave () {
29
+ rm -rf install/data_slave
30
+
31
+ ./install/bin/pg_basebackup -D ./install/data_slave/ -R
32
+
33
+ echo " port = 5433" >> ./install/data_slave/postgresql.conf
34
+ echo " hot_standby = on" >> ./install/data_slave/postgresql.conf
35
+
36
+ echo ' ' > ./install/data_slave/logfile
37
+
38
+ ./install/bin/pg_ctl -sw -D ./install/data_slave -l ./install/data_slave/logfile start
39
+ }
40
+
41
+ make install > /dev/null
42
+
43
+
44
+ pkill -9 postgres
45
+ reinit_master >> /dev/null
46
+
You can’t perform that action at this time.
0 commit comments