5 echo "Stopping Apache."
6 sudo service apache2 stop
8 newname=freeside_test_`date +%Y%m%d`
9 if psql -l |grep -q '^ *freeside '; then
10 if psql -l |grep -q $newname; then
11 echo "Deleting old test database $newname."
14 echo "Renaming test database to $newname."
15 psql postgres -c "ALTER DATABASE freeside RENAME TO $newname"
18 if (sudo grep -q '^test:' /usr/local/etc/freeside/htpasswd); then
19 newhtpasswd=htpasswd_test_`date +%Y%m%d`
20 echo "Renaming htpasswd to $newhtpasswd."
21 sudo mv /usr/local/etc/freeside/htpasswd /usr/local/etc/freeside/$newhtpasswd
22 oldhtpasswd=$( cd /usr/local/etc/freeside; \
23 ls |grep -P 'htpasswd_\d{8}' | \
25 if [ -f $oldhtpasswd ]; then
26 echo "Renaming $oldhtpasswd to htpasswd."
27 sudo mv /usr/local/etc/freeside/$oldhtpasswd \
28 /usr/local/etc/freeside/htpasswd
32 oldname=$( psql -tl | \
35 grep -P 'freeside_\d{8}' | \
38 if [ -n "$oldname" ]; then
39 echo "Renaming $oldname to freeside."
40 psql postgres -c "ALTER DATABASE $oldname RENAME TO freeside"