#dump tdar database
DATE=`date +%Y-%m-%d`
pg_dump -U tdar tdarmetadata > ~/tdarmetadata-${DATE}.sql
pg_dump -U tdar tdardata > ~/tdardata-${DATE}.sql
# sync beta.tdar.org to dev.tdar.org
sudo rsync --delete -avzP abrin@beta.tdar.org:/data/tdar/filestore/ /data/tdar/filestore/
#stop tdar to release DB connections
sudo service tdar stop
#drop and create databases
drop database tdardata;
create database tdardata with encoding 'UTF-8'
drop database tdarmetadata;
create database tdarmetadata with encoding 'UTF-8'
#load datapsql -U tdar tdardata < tdardata-${DATE}.sql
psql -U tdar tdarmetadata < tdarmetadata-${DATE}.sql
sudo service tdar start
# if needed rebuild indexes from within tDAR
sync data from beta to alpha.tdar.org
Skip to end of metadata
Go to start of metadata