5 echo "Stopping Apache."
6 sudo service apache2 stop
8 echo "Resetting clock."
11 newname=freeside_test_`date +%Y%m%d`
12 if psql -l |grep -q '^ *freeside '; then
13 echo "Renaming test database to $newname."
14 psql postgres -c "ALTER DATABASE freeside RENAME TO $newname"
17 oldname=$( psql -tl | \
20 grep -P 'freeside_\d{8}' | \
23 if [ -n "$oldname" ]; then
24 echo "Renaming $oldname to freeside."
25 psql postgres -c "ALTER DATABASE $oldname RENAME TO freeside"
26 echo "Restarting services."
27 sudo service apache2 restart
28 sudo service freeside restart