1 |
|
2 |
echo "setup network" |
3 |
sudo ifconfig lo:1 192.168.0.1 |
4 |
sudo ifconfig lo:2 192.168.0.2 |
5 |
sudo iptables -F INPUT |
6 |
|
7 |
echo "restart database clusters" |
8 |
sudo pg_ctlcluster 8.2 master restart || sudo pg_ctlcluster 8.2 master start |
9 |
sudo pg_ctlcluster 8.2 slave restart || sudo pg_ctlcluster 8.2 slave start |
10 |
|
11 |
echo "create master adsl on 5001" |
12 |
sudo -u postgres dropdb -p 5001 adsl |
13 |
sudo -u postgres createdb -p 5001 adsl |
14 |
sudo -u postgres psql -p 5001 adsl < /home/dpavlin/private/adsl/adsl.sql |
15 |
sudo -u postgres createlang -p 5001 plpgsql adsl |
16 |
|
17 |
echo "create slave adsl on 5002" |
18 |
sudo -u postgres dropdb -p 5002 adsl |
19 |
sudo -u postgres createdb -p 5002 adsl |
20 |
sudo -u postgres psql -p 5002 adsl < /home/dpavlin/private/adsl/adsl.sql |
21 |
sudo -u postgres createlang -p 5002 plpgsql adsl |