Changeset b9e7e26 in osmose-frontend


Ignore:
Timestamp:
Jan 26, 2015 8:50:25 PM (5 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Children:
9b55ebc
Parents:
2e8d7c2
Message:

Add generation of dump of postgresql database, without passwords

File:
1 edited

Legend:

Unmodified
Added
Removed
  • tools/cron.sh

    rec5ceb2 rb9e7e26  
    44 
    55DATABASE=osmose_frontend 
     6DIR_DUMP="/data/work/$(whoami)/" 
    67 
    78psql -d $DATABASE -c "DELETE FROM dynpoi_status WHERE date < now()-interval '7 day' AND status = 'done';" 
     
    3940             ) AS a 
    4041             );" 
     42 
     43pg_dump -t dynpoi_categ -t dynpoi_class -t dynpoi_item -t dynpoi_status -t dynpoi_update_last -t marker -t marker_elem -t marker_fix -t source $DATABASE \ 
     44  | bzip2 > "$DIR_DUMP/planet-dump.sql.bz2.tmp" 
     45mkdir "$DIR_DUMP/export" 
     46mv "$DIR_DUMP/planet-dump.sql.bz2.tmp" "$DIR_DUMP/export/planet-dump.sql.bz2" 
Note: See TracChangeset for help on using the changeset viewer.