/[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

Annotation of /adsl/01_setup_dbs.sh

Parent Directory Parent Directory | Revision Log Revision Log


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

1 dpavlin 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