-- Steps to clean db before shipping 

###login in as root

### stop all services
stop_all

### backup database 
/usr/share/dosis2/bin/dosis-backup --no-vacuum --no-reindex --no-archive

### restart postgresql 
service postgresql restart

### DANGER DANGER 
### RUN clean up script
cd /opt/dosis2/database/tools/.mfg_clean
psql -U dsuper -d dosis2 -f mfg_cleanup.sql

### re-run db setup no switches 
cd /opt/dosis2/database
./db_setup.bash

