install_pg_shard.sh

#!/bin/sh

PG_SHARD_DIR=~/pg_shard
PG_DIR=~/postgresql95
PG_XTM_DIR=~/postgrespro/contrib/pg_dtm


########################################################################
#  Stop old stuff
########################################################################
./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 install # assuming configured with --prefix=./install

cd $PG_SHARD_DIR
make clean
PATH=~/code/postgresql/install/bin/:$PATH make
PATH=~/code/postgresql/install/bin/:$PATH make install

cd $PG_DIR
./install/bin/initdb -D ./install/data1
./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_shard'/" ./install/data1/postgresql.conf
sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = ''/" ./install/data2/postgresql.conf
sed -i '' "s/shared_preload_libraries =.*/shared_preload_libraries = ''/" ./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 '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


./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 5433 << SQL
# CREATE EXTENSION pg_dtm;
# SQL

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

./install/bin/psql << SQL 

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