root/bin/export_analytical_db @ 7434
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" |