root/bin/export_analytical_db @ 7469
| 1 | 6468 | aaronmk | #!/bin/bash
|
|---|---|---|---|
| 2 | # Exports analytical DB
|
||
| 3 | |||
| 4 | selfDir="$(dirname -- "$0")" |
||
| 5 | |||
| 6 | 6730 | aaronmk | cd "$selfDir/.." |
| 7 | 6468 | aaronmk | |
| 8 | 6954 | aaronmk | . "$selfDir/vegbien_dest" |
| 9 | out="backups/analytical_aggregate.$public.csv" |
||
| 10 | 6730 | aaronmk | |
| 11 | 6468 | aaronmk | "$selfDir/psql_script_vegbien" >"$out" <<EOF |
| 12 | 6492 | aaronmk | COPY analytical_aggregate TO STDOUT CSV HEADER NULL 'NULL';
|
| 13 | 6468 | aaronmk | EOF
|
| 14 | 6731 | aaronmk | make "$out.md5" |