changing install_pg_shard_xtm.sh

kelvich · kelvich · commit ae9398af7084 · 2015-10-02T17:47:35.000+03:00
diff --git a/install_pg_shard_xtm.sh b/install_pg_shard_xtm.sh
@@ -1,6 +1,6 @@
 #!/bin/sh
 
-PG_SHARD_DIR=~/code/pg_shard
+PG_SHARD_DIR=~/code/pg_shard_master
 PG_DIR=~/code/postgresql
 PG_XTM_DIR=$PG_DIR/contrib/pg_xtm
 
@@ -42,24 +42,23 @@ cd $PG_DIR
 ./install/bin/initdb -D ./install/data2
 ./install/bin/initdb -D ./install/data3
 
-
-sed -i '' 's/#port =.*/port = 5433/' ./install/data2/postgresql.conf
-sed -i '' 's/#port =.*/port = 5434/' ./install/data3/postgresql.conf
-
 sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = 'pg_dtm,pg_shard'/" ./install/data1/postgresql.conf
-sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = 'pg_dtm,pg_shard'/" ./install/data2/postgresql.conf
-sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = 'pg_dtm,pg_shard'/" ./install/data3/postgresql.conf
+sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = 'pg_dtm'/" ./install/data2/postgresql.conf
+sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = 'pg_dtm'/" ./install/data3/postgresql.conf
 
-sed -i '' 's/#fsync =.*/fsync = off/' ./install/data1/postgresql.conf
-sed -i '' 's/#fsync =.*/fsync = off/' ./install/data2/postgresql.conf
-sed -i '' 's/#fsync =.*/fsync = off/' ./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.use_dtm_transactions=1' >> ./install/data2/postgresql.conf
-echo 'pg_shard.use_dtm_transactions=1' >> ./install/data3/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
@@ -85,46 +84,14 @@ echo "127.0.0.1    5434" >> ./install/data3/pg_worker_list.conf
 ./install/bin/createdb `whoami` -p5434
 
 
-./install/bin/psql -p 5433 << SQL
+./install/bin/psql -p 5432 << SQL
 CREATE EXTENSION pg_dtm;
 SQL
 
-./install/bin/psql -p 5434 << SQL
+./install/bin/psql -p 5433 << SQL
 CREATE EXTENSION pg_dtm;
 SQL
 
-./install/bin/psql << SQL 
-
+./install/bin/psql -p 5434 << SQL
 CREATE EXTENSION pg_dtm;
-CREATE EXTENSION pg_shard;
-CREATE TABLE t(u int, v int);
-SELECT master_create_distributed_table(table_name := 't', partition_column := 'u');
-SELECT master_create_worker_shards(table_name := 't', shard_count := 8, replication_factor := 1);
-insert into t values(1,10000);
-insert into t values(2,10000);
-insert into t values(3,10000);
-insert into t values(4,10000);
-insert into t values(5,10000);
-insert into t values(6,10000);
-insert into t values(7,10000);
-insert into t values(8,10000);
-
 SQL
-
-
-
-
-# insert into t (select generate_series(0,10), random()::integer);
-
-# cd contrib/pg_xtm/dtmd
-# make clean
-# make
-# rm -rf /tmp/clog/*
-# ./bin/dtmd
-
-
-
-
-
-
-
