| 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 |
Parent Directory
| 
Revision Log