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