postgres_cluster/install_pg_shard_xtm.sh at master · gavioto/postgres_cluster · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
#!/bin/sh

PG_SHARD_DIR=~/code/pg_shard
PG_DIR=~/code/postgres95
# we need to move pg_dtm directory there (or better make it directory-independent)
# also apply xtm.patch
PG_XTM_DIR=$PG_DIR/contrib/pg_dtm

########################################################################
#  Stop old stuff
########################################################################
cd $PG_DIR
./install/bin/pg_ctl -D ./install/data1 stop
./install/bin/pg_ctl -D ./install/data2 stop
./install/bin/pg_ctl -D ./install/data3 stop
killall dtmd
rm -rf install


########################################################################
#  Build and run dtm and postgres
########################################################################
make -j 4 install # assuming configured with --prefix=./install

cd $PG_SHARD_DIR
make clean
PATH=$PG_DIR/install/bin/:$PATH make
PATH=$PG_DIR/install/bin/:$PATH make install

cd $PG_XTM_DIR
make clean
make
make install

cd dtmd
make clean
make
killall dtmd
rm -rf /tmp/clog/*
./bin/dtmd &

cd $PG_DIR

./install/bin/initdb -D ./install/data1
./install/bin/initdb -D ./install/data2
./install/bin/initdb -D ./install/data3

echo "shared_preload_libraries = 'pg_dtm,pg_shard'" >> ./install/data1/postgresql.conf
echo "shared_preload_libraries = 'pg_dtm'" >> ./install/data2/postgresql.conf
echo "shared_preload_libraries = 'pg_dtm'" >> ./install/data3/postgresql.conf

echo "port = 5433" >> ./install/data2/postgresql.conf
echo "port = 5434" >> ./install/data3/postgresql.conf

echo 'fsync = off' >> ./install/data1/postgresql.conf
echo 'fsync = off' >> ./install/data2/postgresql.conf
echo 'fsync = off' >> ./install/data3/postgresql.conf

echo 'pg_shard.use_dtm_transactions=1' >> ./install/data1/postgresql.conf
echo 'pg_shard.all_modifications_commutative=1' >> ./install/data1/postgresql.conf

echo "log_statement = 'all'" >> ./install/data1/postgresql.conf
echo "log_statement = 'all'" >> ./install/data2/postgresql.conf
echo "log_statement = 'all'" >> ./install/data3/postgresql.conf

./install/bin/pg_ctl -D ./install/data1 -l ./install/data1/log start
./install/bin/pg_ctl -D ./install/data2 -l ./install/data2/log start
./install/bin/pg_ctl -D ./install/data3 -l ./install/data3/log start


########################################################################
#  Configure pg_shard
########################################################################

echo "127.0.0.1    5433" >  ./install/data1/pg_worker_list.conf
echo "127.0.0.1    5434" >> ./install/data1/pg_worker_list.conf

# echo "127.0.0.1    5433" >  ./install/data2/pg_worker_list.conf
# echo "127.0.0.1    5434" >> ./install/data2/pg_worker_list.conf

# echo "127.0.0.1    5433" >  ./install/data3/pg_worker_list.conf
# echo "127.0.0.1    5434" >> ./install/data3/pg_worker_list.conf


./install/bin/createdb `whoami`
./install/bin/createdb `whoami` -p5433
./install/bin/createdb `whoami` -p5434


./install/bin/psql -p 5432 << SQL
CREATE EXTENSION pg_dtm;
SQL

./install/bin/psql -p 5433 << SQL
CREATE EXTENSION pg_dtm;
SQL

./install/bin/psql -p 5434 << SQL
CREATE EXTENSION pg_dtm;
SQL