/[slony-test]/adsl/10_fill_slave.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/10_fill_slave.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 
 dir=/home/dpavlin/private/adsl  
1  psql="sudo -u postgres psql -p 5002 adsl"  psql="sudo -u postgres psql -p 5002 adsl"
2  $dir/fix_date.pl $dir/200610.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/200610.txt
3  $psql -c 'select count(*) from spajanja'  $psql -c 'select count(*) from spajanja'
4  $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