Skip to content
Snippets Groups Projects
Normal view Permalink
dump-db-more-frequently 364 B
Newer Older
  • Learn to ignore specific revisions
    • Lucas Nussbaum's avatar
    Add script that dumps the DB using pg's custom format
    Lucas Nussbaum committed
    1 2 3 4 5 6 7 8 9 10 
    #!/bin/sh

set -e
cd /srv/udd.debian.org/udd/web/dumps/
umask 022
# exclude dumps from backups, at DSA's request (ivodd 20140101)
touch .nobackup

pg_dump --no-owner -p 5452 -Fc -T ldap -T really_active_dds -T pts -f udd.dump.new udd
mv udd.dump.new udd.dump
    Lucas Nussbaum's avatar
    also dump the schema. this can prove useful sometimes. :-)  
    Lucas Nussbaum committed
    11 12 13 
    
pg_dump --no-owner -p 5452 --schema-only -f udd-schema.sql.new udd
mv udd-schema.sql.new udd-schema.sql