/[slony-test]/adsl/01_setup_dbs.sh
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /adsl/01_setup_dbs.sh

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1 - (show annotations)
Sun Feb 11 21:52:48 2007 UTC (12 years, 4 months ago) by dpavlin
File MIME type: application/x-sh
File size: 759 byte(s)
initial import

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

Properties

Name Value
svn:executable

  ViewVC Help
Powered by ViewVC 1.1.26