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 oldname=$( psql -tl | \
21 grep -P 'freeside_\d{8}' | \
24 if [ -n "$oldname" ]; then
25 echo "Renaming $oldname to freeside."
26 psql postgres -c "ALTER DATABASE $oldname RENAME TO freeside"