/[slony-test]/adsl/12_fill_master.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

Diff of /adsl/12_fill_master.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 6 by dpavlin, Sun Feb 11 21:52:48 2007 UTC revision 7 by dpavlin, Tue Feb 13 12:05:42 2007 UTC
# Line 1  Line 1 
1  echo "sync changes on all nodes"  echo "sync changes on all nodes"
2  slonik_execute_script -c 'select now();' 1 | slonik  slonik_execute_script -c 'select now();' 1 | slonik
3    
 dir=/home/dpavlin/private/adsl  
4  psql="sudo -u postgres psql -p 5001 adsl"  psql="sudo -u postgres psql -p 5001 adsl"
5  $dir/fix_date.pl $dir/200611.txt | $psql -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;'  $psql -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200611.txt
6  $psql -c 'select count(*) from spajanja'  $psql -c 'select count(*) from spajanja'
7  $psql -c 'select * from po_mjesecima'  $psql -c 'select * from po_mjesecima'
Legend:
Removed from v.6  
changed lines
  Added in v.7
  ViewVC Help
Powered by ViewVC 1.1.26